I have a package with a chain of 14 tasks, if they all succeed, that is stopping at task 3 and reporting success for the whole package when I debug it. All 3 steps go yellow, and then green as they are processed and the data flow task successfully moves data (Excel to SQL Table) but the package the nfails to move on to the next step - a script task to check a file exists before another dataflow task.
Have I set a property somewhere that is causing this? I was debugging step 2 with a breakpoint in the script but have removed that now. step 2's failure constraint passes processing to step 4. If that fails the package stops at step2, reporting success.
New to SSIS and not entirely enjoying it yet so any ideas greatly appreciated.
asked Sep 08, 2010 at 03:21 AM in Default
OK. I have the resolution. As I explained, Task 2 has constraints - fail go to 4, success go to 3; Task 3 has constraints - fail go to 16, success go to 4.
The issue was with the constraints Task2 fail and Task3 success, I had their LogicalAnd properties set to True. This meant that the package process was expecting both Task2 to fail AND Task3 to succeed before it moved on to Task4, otherwise it was completing with success.
Setting the LogicalAnd property to False resolved the issue
answered Sep 08, 2010 at 04:17 AM