row_num is the indentity column i have created in the temp table , where the run_duration > 18000 data enters into temp table and this colomn values increases by 1.

i...

can anybody please help ne writing the condition here ,

the procedure given in link is such a big one and i dont have permissions for doing so...

How do i create a package for the systemtable in MSDB, because i cannot see the system tables, when i select from ole db source connection...

I need to create Job...

Could you please elloborate it?

There are options only when Job suceeds,fails and completes, and i have about 15Jobs schedules for my Database, how can i schedule the Job for all...

ok, so now am trying with Lookup transformation , the stored procedure i tried for the other package is running fine , the source for that package was from another...

wow!!! Thats Amazing ...i replaced the syntax it worked !!!Initailly it got stuck at the same point i waited for while and amazingly it ran and completed the Job ...

Thank...

could you please let me know why we have used where ec_step_id is Null?

As there are no nulls in ec_step_id.....

Thank you so much for the explanation

Actually i am new to SSIS packages, someone suggested that having a temp table as stataging would let us have the back data or...

Hey i have inserted the Data manually i mean by insert statement giving the same syntax to select the Data from Temp,

After inserting the Data , i ran my Package...

I created index on ec_step_id :crying:, that did not work too .......again hanged....

no, i dont have any indexes........

should i or should'nt i have??

Not Sure whats wrong with the file ,

here are the results, before, while and after execution os the package, i dont see much difference

Database NameLog Size (MB)Log Space Used (%)Status

tempdb8.17968849.379180

tempdb8.17968853.008590

tempdb8.17968858.022920

Attached is the Excel File with Results........

Not sure about it ,How do i check that?

I am new to SQL SERVER, please help me if am missing something here.....

I have Control Flow SQL task which deletes all the Temp table Data everytime package begins.........