executionorder in logfile - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

executionorder in logfile

Author

Topic

vafan30
Starting Member

2 Posts

Posted - 2008-11-20 : 03:20:36

I have a dts package with several datapumps to one source and the on success rellation to DTSStep_DTSExecuteSQLTask_3 and then onsuccess reallation to DTSStep_DTSActiveScriptTask_2.
however, when i look in the logfile it seems like DTSStep_DTSActiveScriptTask_2 and DTSStep_DTSExecuteSQLTask_3 starts before data pump 4 is completed.

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_2
DTSRun OnStart: DTSStep_DTSDataPumpTask_3
DTSRun OnStart: DTSStep_DTSDataPumpTask_4
DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 380 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 380
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_5
DTSRun OnProgress: DTSStep_DTSDataPumpTask_5; 1 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1
DTSRun OnFinish: DTSStep_DTSDataPumpTask_5
DTSRun OnProgress: DTSStep_DTSDataPumpTask_3; 3 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3
DTSRun OnFinish: DTSStep_DTSDataPumpTask_3
DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 7 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 7
DTSRun OnFinish: DTSStep_DTSDataPumpTask_2
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3
DTSRun OnStart: DTSStep_DTSActiveScriptTask_2
DTSRun OnProgress: DTSStep_DTSDataPumpTask_4; 26 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 26
DTSRun OnFinish: DTSStep_DTSDataPumpTask_4
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2
DTSRun: Package execution complete.

shaunc
Starting Member

28 Posts

Posted - 2008-12-02 : 17:16:28

Double check that ActiveScriptTask_2 and ExecuteSQLTask_3 really have a "success" precedence constraint pointing back to DataPumpTask_4. Any time I've seen this happen, it's been because I forgot one somewhere. They're particularly easy to miss on the data pump tasks since they're the same shape.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources