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)  DTS error mechanism

Author  Topic  mduong Starting Member 1 Post Posted - 2005-02-15 : 17:17:32 Does anybody have any idea how DTS errors out? Specifically does it process a step then generates an error or does it halt the step when it hits an error? I have a scheduled package that seems to be erroring out between steps. The process seems to be like this. It will run a step then error out before getting to the next step. Step 5: sql command 1 stored procedure1 call sql command 2 Step 6: sql command 3 store procedure2 call sql command 4 I made Step 6 dependent on the success of Step 5. To try to track down the error, I placed insert statements at different points to track flow by inserting into a log table with statements like "Reached step 6.1", "Reached Step 6.2" The peculiar thing is that it seems to complete all of step 5. It will run sql command2 but never hits sql command 3 (which is a insert tracking step). I can run the package manually and never get any errors.