I have the following parallel execution defined in my DTS
Designer:
Note: All databases, DB1, DB2, and DB3 are SQL Server 2000
dbs
Delete Old Data From DB2(Execute SQL Task)
^
Quote:
(Parallel Exe.) |(On success)
DB2<------------- DB1
|
Transform Data Tk ^
(On success) |
Quote:
(Transform Data Task)
DB3
|
The package is running the way I want it to run because
even though the "Delete Old Data From DB2" and
the "Transform Data Task" between DB1 and DB2 are
parallel, when I run the package "Delete Old Data From
DB2" runs before the "Transform Data Task". How do I know
that the "Delete Old Data From DB2" task will always run
before the "Transform Data Task"?
Please help.
Thanks.
Derek