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.

more ▼

asked Sep 08, 2010 at 03:21 AM in Default

avatar image

Fatherjack ♦♦
43.8k 79 102 118

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Sep 08, 2010 at 04:17 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

I was just about to type that in. Welcome to SSIS land

Sep 08, 2010 at 04:57 AM Daniel Ross

Oh man, its so aggravating isnt it? Not having an easy intro to it. Can you recommend any books/learning/reference materials?

Sep 08, 2010 at 05:04 AM Fatherjack ♦♦

Thats right Fatherjack its very hard to find SSIS 2008 ebooks! Its little surprising that even microsoft didn't issued any press release of SSIS 2008 ebooks

Sep 08, 2010 at 05:13 AM Cyborg

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.

Sep 08, 2010 at 06:47 AM Daniel Ross

maybe you should accept this as the answer? Or can you not see the tick as some users have reported?

Sep 09, 2010 at 03:31 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 08, 2010 at 03:21 AM

Seen: 3389 times

Last Updated: Sep 08, 2010 at 03:21 AM

Copyright 2018 Redgate Software. Privacy Policy