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.
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..
DTS Step2 runs before Step1
Posted - 02/25/2011 : 21:38:12
