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 |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2009-01-29 : 12:29:27
|
| GreetingsIs it possible to ROLLBACK all changes et inserts to tables if one SQL task fails...How do you do that? is there a roll back feature?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-29 : 12:34:47
|
| yup. you can do that by means of sequence container. put all the tasks you want to part of transaction inside a sequence container and make the transaction property of container as required. this will cause a new transaction to start each time control enters sequence container. In event of any error in any of tasks within container, all the changes done inside will be rollbacked. |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-01-29 : 12:59:08
|
| DANG! SSIS is very confusing because it is so rich, what a powerful tool! if SQL were heaven visakh16 would be SQLeity (a SQL deity).Thanks man! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-29 : 13:01:39
|
welcome  |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-01-29 : 15:20:25
|
| Vwhen you say: "put all the tasks you want to part of transaction inside a sequence container and make the transaction property of container as required." property of the sequence container or the main package? Because I have two sequence containers and when I set both of their transaction property to required the first one fails instantly...Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-30 : 12:53:39
|
| i meant property of sequence container. |
|
|
|
|
|
|
roll back SSIS changes