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 |
|
sonu
Posting Yak Master
110 Posts |
 Posted - 2011-02-25 : 21:38:12
|
| Hi, I have a sql 2000 dts package that has several steps in it. One of the steps is to (step1) truncate table x - the next step right after that is a (step2) data transformation task, which insert new data into the truncated table. Very often though I see that the transformation task runs before the table is truncated. I am not sure if this is a bug, or if I made a mistake somewhere. The precedence from step1 to step2 is Success.Thanks |
|
|
vinurvk
Starting Member
8 Posts |
Posted - 2011-02-26 : 14:09:04
|
| try creating a separate package with these 2 steps alone and see how it behaves.. if you have set the work flow properties correctly - there is no way the step2 can get executed before step1.. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-28 : 13:52:42
|
| yep, check your workflow properties |
|
|
|
|
|
|
DTS Step2 runs before Step1