Oh - just saw your post about Validation Phase. OK, that is relieving. Thanks!

http://stackoverflow.com/questions/3255454/can-ssis-execute-tasks-in-specific-order

and here's one about FTP task failing due to bad connection, even though the connection would have been correct AFTER the first task had executed, despite precedence constraints.

Lastly,...

Just the fact that I have precedence constraints for "success AND [variable]", yet if the 2nd box has errors, those errors end up getting raised.

Why, if they weren't...

OK sounds good - so it's not just about the order of the arrows and boxes, it's about precedence constraints. That makes sense to me.

I'm not sure I won't...

Totally agree that it should be that way and/or looks that way?, but that's not actually what I've found, and numerous sources (forum threads and articles on the web) agree...

Read Kimball's The Data Warehouse Tookit, 3rd edition. Google it; it's a free PDF download and also the most authoritative, comprehensive guide of all time for helping you formulate...

I agree. That's what I'm actually finding to be true. There doesn't actually seem to be a need to turn it off; once the script runs I run...

Ahh yes...I'd forgotten about that small thing 🙂

Understood. Thanks

Luis Cazares:

I was thinking more about your post and realized I was unsure whether I had for sure turned back off Identity Insert for each table I recently ported to...

Thanks to both of you for the assistance.

Because the documentation on IDENTITY INSERT states that you have to explicitly pass the value to insert into PK field.

Not true?

Craig, that looks like the same solution/examples I already had.

So you're passing values explicitly in the sql insert. I know how to do that.

I have...

Thank you! I had seen some [extremely] complex solutions on stack overflow and I was starting to think there was a simpler, variable-driven way.

Thanks.