Check Points issue with sequence container RRS feed

  • Question

  • Hi i am new to ssis tool, i am working with small control flow task(cft) where it contain 5 data flow task(dft) in sequence container i have mapped in a way that dft2 should run after dft1 run successfully and dft4 should run after dft3 run's successfully all these 5 dft's are in sequence container. I have applied check point property (xml file created, save check point:true, checkpoits usage:if exist). when i ran the package for first time dft1 got successful dft5 got successful but dft3 got failed. i have checked for xml file its present, but when i ran the same package for 2nd time again then execution should start from dft3-->dft4, dft2 only should run but in my senario all the dft1 dft5 are also executing which should not happen. 

    Please help me what is the problem, where i am going wrong, if?

    Please suggest me some solution for this.I will look forward for help.



    Wednesday, July 6, 2016 5:56 AM