greetings,

i have an sql dts package that is supposed to run on a loop. each pass of the loop calls the dts package followed by a connection.execute statement that does some data manipulation on the table populated by the dts.  

the question is, how can i make the connection.execute statement run only after the dts package is completed.

as a workaround, i pause 5 seconds after each dts run, which is of course not acceptable.

help please

thanks

Hi,
DTS has a task dependency feature. Join your tasks with an "onsuccess" path and your code will only run after the previous task has completed.

Hope this helps
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)