asked
SSIS debugging stop with success in the middle of the package
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.
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
Oh man, its so aggravating isnt it? Not having an easy intro to it. Can you recommend any books/learning/reference materials?
it is a steep learning curve, I did a MS training course a few years back, and basically learnt from there. Once you have gotten the basics though, it is a fantastic tool.
maybe you should accept this as the answer? Or can you not see the tick as some users have reported?
