Solved

SSIS Package Transaction Integrity

Posted on 2006-11-07
2
261 Views
Last Modified: 2008-01-16
1) I created many data flow task packages.

2) Then a execute package task in which I ordered relationally execute above data flow packages.

3) What I find is when a package fails, it is rolled back, execution stops but not the packages before this failed one.

4) What to do to rollback all in case of error and commit only if all are successfully executed?
0
Comment
Question by:k_murli_krishna
2 Comments
 
LVL 12

Accepted Solution

by:
Einstine98 earned 75 total points
Comment Utility
I'm not sure, but I think this beats the design objective... to me, a package is standalone, if it ran successfully, I wouldn't want it to roll back... so all the logic that needs the success/failure should be in one package... this way you can pickup from where you stopped, this is the only way to go when you do a few GB data load daily!
0
 
LVL 17

Author Comment

by:k_murli_krishna
Comment Utility
There are execute package task and data flow task level transaction attributes & we tried them but we failed. Can you please post the exact name of these attributes and values to fix for them. Right now, each data flow task is event handled with suitable truncate table script for OnError.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now