sql server dts: DTS Step should run Last -- sql server dts

DTS Step should run Last

(jariwala_b NO[at]SPAM rediffmail.com)
12/25/2005 9:23:32 PM

sql server dts: 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/

Re: DTS Step should run Last

Allan Mitchell
1/3/2006 2:27:45 PM

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

[quoted text, click to view]