Transactions Control in parent child packages SSIS ?

• mohsinmpz 48760

  SSC Journeyman

  Points: 77

  More actions

  July 2, 2015 at 10:16 am

  #318653

  I have parent package in which i have foreach loop for counting flat files and within it i process each file one by one while calling(Exec package task) child package where i have sequence container. While in child package sequence container i have two flow tasks

  -one is for deleting data from import schema tables and import all data from flat file into it which is passed by parent package.

  -second is moving new and updated rows from import schema to staging tables.

  Now i set "required" transaction property for parent control flow while all other components in it are "supported".

  and set "supported" transaction property for child control flow and same for all components in it. So when i execute the parent package it stuck at second flow task in the child package.

  I want to rollback all transactions if any error occur or failure in any package

  Please any help will be great.