exit dts

[fmardani]

Half way through a dts, there is a task that runs a sp
Based on the result of this sp, I would like to exit from the dts half way through it.
Thanks

 

[JohnDTampaBay]

Use an ActiveX script to connect to the database and run the stored procedure. Capture the result of the stored procedure. Use scripting to pass or fail the step based on the stored procedure result. Use a workflow connection On Success to the next step of the DTS package.

I have probably left some details out, but that's the basics I think. Good luck!

--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)