I have created one DTS package with 5 tables transfer from source to destination db.I am transfering incremental data from source comparing timestamp column value from each of these tables.for this to i am storing datetime value in global varaible called Last_Export_Date.

I am updating Last_Export_Date after all tables transfer has done.this step should execute at the end.

I have 5 different workflow in my package.problem is that last step (updating Last_Export_Date) sometimes occured before all tables transfer gets finish.

so my question is that how can i create step that occured at the last stage.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Hello Bharat,

Make sure that all your tasks have an On Success constraint that points to
the final task. This way all 5 of your previous tasks must complete before
the final task executes.

Have a look here


Introduction to Workflow
(http://www.sqldts.com/default.aspx?287)



Allan