Rollback ENTIRE SSIS Package if a step Fails
I built an SSIS package. The first step of it imports data from a csv into a local table. The next 5 steps are EACH a sql execute task. If ANY of the steps fail I want to rollback the transactions for the ENTIRE package INCLUDING the data import. If this isn't possible then just being able to rollback the sql execute tasks would be enough.
How can i do this. Can i use try/catch blocks? That would also be preferrable as the code for a try/catch IS MUCH simplier then the code i used to need in sql 2000 transactions.
How can i do this. Can i use try/catch blocks? That would also be preferrable as the code for a try/catch IS MUCH simplier then the code i used to need in sql 2000 transactions.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER