SSIS/ Sequence Container Problem Help.

• rocky_498

  SSCertifiable

  Points: 6532

  More actions

  November 13, 2014 at 10:41 am

  #295097

  Hi,

  I am having a problem in my SSIS Package. Simple package.

  First Step:- Using SEQUENCE CONTAINER

  Second Step:- Inside SEQUENCE CONTAINER truncating staging table through SQL Task and using data flow to inserting data from .CSV to staging table and then Updating some field through SQL Task.

  Here is the problem. I am using SEQUENCE CONTAINER when I select SEQUENCE CONTAINER PROPERTIES (transaction Option = REQUIRED). Data flow task stay YELLOW forever. If I change SEQUENCE CONTAINER PROPERTIES (transaction Option = Supported ) everything working fine. Is anyone can help me what I am doing wrong?

  I know someone want to know why I am using SEQUENCE CONTAINER PROPERTIES (transaction Option = REQUIRED). I want If any task fail everything roll back or nothing happen..

  Thanks in advance.