Link to home
Create AccountLog in
Avatar of Mr_Shaw
Mr_Shaw

asked on

ssis sequence containers

I have a sequence container which contains three data flows.

Each data flow contains tasks which insert data into a table.

My question is... if one of the data flows inside the sequence container fails will it prevent/rollback the data from the other two data flows?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Jason Yousef
Jason Yousef
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Mr_Shaw
Mr_Shaw

ASKER

What you are saying is that If task1 and task2 are a success but task3 fails the sequence container will fail.

Will the data from task1 and task2 commit?

YES
YES
You can change that behavior, if one step fails the whole container fails.
but I don't think that's what you want.
Avatar of Mr_Shaw

ASKER

No want I want is that if any of the tasks within the container fails the data will be rolled back on not commited.

Is this possible?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of Reza Rad
Reza Rad
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Mr_Shaw

ASKER

thanks i'll have a look at work tomorrow and dish out the points!
Avatar of Mr_Shaw

ASKER

here is a screen shot of my package.

If either Inpatients, Outpatients or AE fails I need to rollback/delete what was inserted into the table so that I can start again.
ssis-rollback1.bmp
Avatar of Mr_Shaw

ASKER

thanks