Post reply

Conditional Execution in SSIS 2005

  • May 27, 2010 at 4:12 pm

    #141253

    I have two variables: varNewPeriod and varCurrentPeriod. If varNewPeriod > varCurrentPeriod, I want to build a string and run it in a certain Execute Process Task within a Foreach Loop Container. I don't see any conditional (if/then) Control Flow Items in SSIS 2005. So how can this be done? Can a script run an Execute Process Task?

  • May 27, 2010 at 7:22 pm

    #1173673

    Use Expression and Constraint Option. This may help.

  • May 28, 2010 at 12:30 am

    #1173737

    imani_technology (5/27/2010)

    I have two variables: varNewPeriod and varCurrentPeriod. If varNewPeriod > varCurrentPeriod, I want to build a string and run it in a certain Execute Process Task within a Foreach Loop Container. I don't see any conditional (if/then) Control Flow Items in SSIS 2005. So how can this be done? Can a script run an Execute Process Task?

    You can do this. Read up on 'Precedence Constraints'.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 3 posts - 1 through 2 (of 2 total)

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