May 27, 2010 at 4:12 pm
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
Use Expression and Constraint Option. This may help.
May 28, 2010 at 12:30 am
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
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply