SSIS Sequence Container


Guys,

I need your help in understanding this. I have created a SSIS package which includes a sequence container which includes two DFTs (see the attched doc). On execution when one DFT fails the Sequence container does not show failure but the parent package shows the failure from where it was called. Can you please help me understand this.. what should I do to make it fail if any of the DFTs fail...

Thanks for help..
sequence-container-failure.doc
banjara15Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
banjara15Connect With a Mentor Author Commented:

Ok, I got the problem resolved. Somehow the DFT's got delinked from the Sequence container, so I recreated another container, moved the DFTs to the new one and removed the old container. Tested and it worked.. :)
0
 
chapmandewCommented:
On the properties on the seq. container, do you have the FailPackageOnFailure and the FailParentOnFailure both set to True?
0
 
banjara15Author Commented:

No by default both are set to False
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
chapmandewCommented:
try changing those settings to see if you can achieve what you want.
0
 
banjara15Author Commented:

Just made the change and tested. It is still the same...
0
 
chapmandewCommented:
In that case, I am not sure that a sequence container actually can be made to "fail" in your situation.
0
All Courses

From novice to tech pro — start learning today.