Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
 Posted - 2010-06-08 : 09:41:25
|
| Hey folks, what is the best way to wrap and SSIS package in a transaction so it rolls back if there are any errors? I have one master package that calls many sub packages that do simple data flow tasks. Thanks. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-06-08 : 10:25:55
|
| Okay, so if I have a master package that truncates all the tables, then runs sub packages, if I set the TransactionOption to Required, will it automatically rollback if there any failures in the sub packages or do I need to set their transactionoptions too? thanks. |
 |
|
|
|
|
|
Commiting and rolling back transactions in SSIS