June 24, 2010 at 11:40 pm
Like if variable = 'AB' run Data flow task 1...
I use Scirpt Task to set variable "NeedImport" value
if [User::NeedImport] = True
Execute Task 1 ............
else
Execute Task 2............
How i solve this in SSIS ?
June 25, 2010 at 6:04 am
In SSIS you can use the precedence constraints (green, blue, red arrows) to control the flow of your package.
Double click on an arrow and you will arrive in an edit screen. There you can set that the constraint should follow an expression. Use your variable there.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 25, 2010 at 10:44 am
you guys did a big deal for me ,thanks ...
ahaha
i'll have a try
June 28, 2010 at 2:21 pm
That advice is right on, and unfortunately not very obvious to the newer users in SSIS.
CEWII
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply