I have written a stored procedure that uses sp_OACreate, sp_OAGetProperty etc system stored procedures to create DTS packages, and set some of their parameters. How can I get the DTS package, when it executes, to join the same transaction that my calling stored procedure has started? I.A.W. if my stored proc does a rollback, so should the DTS package.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTS and transactions
- Thread starter ludek
- Start date
Similar threads
- Locked
- Question
- Locked
- Question