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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-01-25 : 04:29:16
|
| Dear All,I need a help on flow of control.below is the issue I am Using sequence container to do my list of task,inside sequence container i am using two sets of column operation(i mean i am updating 2 tables separately). One table load got failed due to some issues,but other sequence got executed successfully within sequence container.In the package log it shows package got failed.My question is the the other sequence (data upload ) inside sequence container will loaded the data or rolback ? Thanks,Gangadhar |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-25 : 06:22:00
|
| that depends on whether you're associating sequence to transaction or not. what have you set as transaction property value for sequence generator? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-25 : 06:52:34
|
| also seehttp://www.mssqltips.com/tip.asp?tip=1585 |
|
|
|
|
|
|
Flow of control