x

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 '10 at 03:21 AM in Default

Fatherjack gravatar image

Fatherjack ♦♦
41.3k 73 77 107

(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 '10 at 04:17 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.3k 73 77 107

I was just about to type that in. Welcome to SSIS land
Sep 08 '10 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 '10 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 '10 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 '10 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 '10 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1816
x900
x4

asked: Sep 08 '10 at 03:21 AM

Seen: 2179 times

Last Updated: Sep 08 '10 at 03:21 AM