SQL Server Performance

How to set a roll back in case of a failure in the SSIS package.

Discussion in 'SQL Server 2008 General Developer Questions' started by Varsha, Jul 24, 2009.

  1. Varsha New Member

    Hi,
    I have a package which has 4 steps and let say the package fails while executing at step 3. Now i want to rollback everything whatever was done in step 1 and step 2. How do i apply rollback to the SSIS package??
    Thanks,Varsha
  2. MohammedU New Member

Share This Page