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.
| Author |
Topic |
|
arungulli
Starting Member
5 Posts |
 Posted - 2004-07-19 : 10:43:40
|
| We have a DTS package with multiple "Execute SQL Tasks", "Transform Data Tasks" and "Active X Tasks". Multiple "Execute SQL tasks" run in sequence and after the "Success" of them the "Transform Data Tasks" are set to kick of in parallel. We have a log table setup into which status of the DTS tasks are inserted. That is after success/failure of each step a record is inserted into the log table with date time stamp.When we look at the records in the log table, the date time stamps in the log table say that the tasks are not executing in the correct sequence. That is the 1 or 2 of the "Transform Data Tasks" which should start after the "Execute SQL Tasks" are starting before. That too each time it happens with a different "Transform Data Task". Out of every 10 runs this seems to occur once, that it is random and intermittent.Please let me know if anyone encountered such an absurd behavior in the workflow of tasks. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-07-19 : 12:57:41
|
| Is the insertion of the log recs part of the workflow sequence? i.e. are the tasks dependent on the log file insertions rather than the steps being recorded.If not then that could account for it.When you say before are they actually the same time? SQL Server only holds time to within a few millisecs so can do quite a few operations at seemingly the same time.Other than that it's unlikely that a task is staring before it's dependencies are complete.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DTS Task Sequence