?
Solved

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

Posted on 2004-09-08
1
Medium Priority
?
451 Views
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

P
0
Comment
Question by:Philbee
1 Comment
 
LVL 34

Accepted Solution

by:
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).
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

807 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