Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Condisional Split in Control Flow?

Author  Topic 

Ali Chadorbaf
Starting Member

44 Posts

Posted - 2008-03-11 : 16:51:46
Hi,
I would like to have a decision maker component in Control Flow to decide which Data Flow to run.
For example:
if myVar=A then run data flowA
if myVar=B then run data flowB
......

We have Conditional Split component available in data flow but not in Control Flow. What component in control flow can be used to do the same job that conditional flow is doing in data flow? Or what's a work around for this.

Thanks in advance.

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2008-03-12 : 08:40:53
Use an expression on a precedence constraint. BTW, try not to think of the control flow and the data flow in the same terms - they're very different!

Mark
Go to Top of Page
   

- Advertisement -