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

  • Andy Leonard

    SSCrazy Eights

    Points: 9865

    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

  • mtassin

    SSC-Insane

    Points: 23035

    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

    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

    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

    SSCrazy Eights

    Points: 9865

    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: 9241

    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

    SSCrazy Eights

    Points: 9865

    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

    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?

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

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