DTS - commit all transactions only on successful completeion of whole package

Posted on 2004-09-08
Medium Priority
Last Modified: 2010-05-18
Using DTS, how can I make it so I only commit transactions on successsful completion of the whole package and all 10 seperate transactions?  i.e. if 1 dts fails, then all previously successful transdactions are rolledback?

Many thanks

Question by:Philbee
1 Comment
LVL 34

Accepted Solution

arbert earned 400 total points
ID: 12007847
Open your package in designer.  Right click on the designer screen and choose package properties.  Click on the advanced tab.  make sure you have the "Use Transactions" check box checked.  Then, click ok.  Now, if you click on the transformation line between your inputs and outputs, click on the options tab, you can select the transactions settings you need for your job (join transaction if present, rollback on failure).

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question