Advanced SSIS Workflow Management – Step 8 of the Stairway to Integration Services

Question

Advanced SSIS Workflow Management – Step 8 of the Stairway to Integration Services

Andy Leonard

SSChampion

Points: 10144
More actions
September 12, 2012 at 12:02 am

#281435

Comments posted to this topic are about the item Advanced SSIS Workflow Management – Step 8 of the Stairway to Integration Services
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

mtassin SSC-Insane Points: 23099 More actions · Answer 1

Nice Article.... wish I had read it last week when I was working on a project that needed a bunch of conditional processing... This was just the ticket on what I was working with... 🙂

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

GMW-370752 Valued Member Points: 67 More actions · Answer 2

This is a great article that does a good job of stepping through a lot of complex property setting combinations. I loved the section on Precedence Constraint Annotation as this really helps display what is going on right on the design surface and is something I immediately added to one of my packages.

Richard Parsons-65 SSChasing Mays Points: 614 More actions · Answer 3

Hi Andy - great article, as ever. I can't see that I didn't follow your instructions to the letter but during the Mixing Constraint and Expression Evaluation Operations section I couldn't even close the Precedence Constraint Editor window. This is because @MyBool is set to false (and a positive condition will never be met). Subsequently I couldn't execute the package, for obvious reasons. Any reason why it worked for you, but not for me?

Thanks,

Richard

Andy Leonard SSChampion Points: 10144 More actions · Answer 4

Richard Parsons-65 (12/19/2012)
Hi Andy - great article, as ever. I can't see that I didn't follow your instructions to the letter but during the Mixing Constraint and Expression Evaluation Operations section I couldn't even close the Precedence Constraint Editor window. This is because @MyBool is set to false (and a positive condition will never be met). Subsequently I couldn't execute the package, for obvious reasons. Any reason why it worked for you, but not for me?
Thanks,
Richard

Hi Richard,

I am not certain why this is happening. But, referencing your other comment on another article in this series: Does your machine has enough RAM available?

Andy

Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

dwilliscp SSCrazy Eights Points: 9270 More actions · Answer 5

Hey Andy,

I realy love this group of articles, but I would request you make a slight change to Step 8. Under the section "Copying and Disabling to Preserve Existing Work" I got a bit lost and suggest making the following change:

From: Drag a Sequence Container onto the Control Flow as shown in

To : From the toolbox, drag a Sequence Container onto the Control Flow as shown in

Thanks,

David

Andy Leonard SSChampion Points: 10144 More actions · Answer 6

Thanks David,

I have submitted the update. Usually Steve approves them and the updates appear within a couple days.

:{>

Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

vlg2k SSC Enthusiast Points: 172 More actions · Answer 7

Hi, Andy,

First, thanks for putting this series together. Good job!

But... this article seems to contain a typo not mentioned in yet the discussion:

After fig.35, the text

"Script Task 3 will execute after either Script Task 4 and Script Task 2 executes and succeeds."

should read as follows:

"Script Task 3 will execute after both Script Task 4 and Script Task 2 execute and succeed."

Correct?