SQL Server DTSDiscussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Server DTS section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
In one of my DTS package I have three Transform Data Tasks. I want to ensure if any of the Transform Data Task fails, all the tasks should be Rollback.
I have enabled the following options in DTS package's Advanced properties:
- Use transaction
- Commit on successful package completion
- Transaction isolation level: Read commited
Even though if any of the above Transform Data Task fails, DTS commits for the remaining successful tasks. As per my knowladge it should not happen as I have enbled above options in DTS to use the transaction.
Or does DTS will takes care in such case if I enable the following options in each of the task's WorkFlow properties?
- Join transaction if present
- Rollback transaction on failure
Can anybody advice me how DTS use Transactions. Why does it get failed in first case?
Transaction in Transform Data Task - DTS
Linear Mode
