Rollback to handle in SSIS

• navigatejai

  SSC Veteran

  Points: 204

  More actions

  December 19, 2011 at 3:06 am

  #391158

  Hi,

  I have a master package which contains 6 Execute Package task.

  First 3 Execute Package task is used to extract the packages (ie Claim extraction, Claim Status Extraction and Claim Handler Extraction)

  And the remaining 3 EPT is used to load the data into the 3 tables (Claim ,Claim Status and Claim Handler)

  Claim Status and Claim Handler are type 2 dimension tables.

  Problem : After the extraction and loading claim table and Claim status tables gets loaded but the claim handler which dose not have the matching records the data was not loaded.

  So i have to roll back the data that has been loaded in the claim and claim status table?

  Is it possible to do it in the SSIS package level?

  Waiting for your valuable suggestions

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  December 19, 2011 at 5:30 am

  #1423053

  Put the 3 EPT's inside one container and enable transactions on that container.

  http://www.mssqltips.com/sqlservertip/1585/how-to-use-transactions-in-sql-server-integration-services-ssis/

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP