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 |
|
Ali Chadorbaf
Starting Member
44 Posts |
 Posted - 2008-01-21 : 13:16:06
|
| Hi,I am a newbie in SSIS. I'd like to hear your recommendation to build the whole SSIS package as one transaction. In other words, how we can rollback all DML operations (insert/update/delete) that are applied in different parts of a package if for any reason the package failed to complete?. Something like rolling back a proc if the proc failed.Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-22 : 02:58:13
|
| You can place what all tasks you require to be part of a transaction in a container like sequence container and change the transaction property of container to 'Required'. This ensures any error inside any of tasks in container will cause the entire data manipulation inside container to be rolled back. |
 |
|
|
Ali Chadorbaf
Starting Member
44 Posts |
Posted - 2008-01-24 : 13:18:47
|
quote:
Originally posted by visakh16
You can place what all tasks you require to be part of a transaction in a container like sequence container and change the transaction property of container to 'Required'. This ensures any error inside any of tasks in container will cause the entire data manipulation inside container to be rolled back.
This is great. Thank You!!! |
|
|
|
|
|
|
SSIS package as one Transaction