precedence constraint at data flow level, how?
Experts, Conditional split is not helping me out. I have 1 oledb Source, 1 multicast & 3 destination(2 txt destination & 1 excel destination). Now, based on my package value (0 or 1) I wan't to execute 3 destination task accordingly, meaning:- 0 than execute only 2 txt destination but NOT excel destination 1 than execute only excel destination and not 2 txt destination Any help please? Thanks KumarPlease do let us know your feedback. Thank You - KG, MCTS
November 9th, 2011 5:26pm

you probably have a package variable which has value ( 0 or 1 ), in the data flow task, before conditional split add a derived column transform and write this expression to create new column based on variable's value: @[User::MyVariable] note that you should use your variable name instead of MyVariable. name the output column as FlagColumn then in conditional split use this expression: [FlagColumn]==0 name this output as TxtOutput and name default output as ExcelOutput after the conditional split connect TxtOutput to multicast, and then connect two output from multi cast to two txt destination and connect ExcelOutput to excel destinationhttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 9th, 2011 5:37pm

Hi Again, Wow... lot of work for just a small request. Will give a short for sure to make it workable, I was think SSIS should have some simple as "Precedence Constraint at Data Flow level too" Thank You Reza. KumarPlease do let us know your feedback. Thank You - KG, MCTS
November 9th, 2011 5:44pm

Data flow hasn't any control flow component, I mean redirecting from one component to another is a control flow task. and in the data flow task there is no precedence constraint, the arrows here are Data Path. so if you want to implement such thing, you have two ways: 1- use the method I described in my previous post to create a control flow like way. OR 2- implement part of it in control flow, a sample of this way can be: load your desired data stream ( what you want to load in txt files or excel files ) into a Raw Destination and into a Raw file then go back to control flow, and add two new data flow tasks, in one of them add a Raw File source, and single Excel destination in second one add a Raw File source and multi cast and then two flat file destination. and implement an IF condition in precedence constraint and redirect to appropriate data flow task. I've wrote a sample of IF condition implementation in precedence constraints here: http://www.rad.pasfu.com/index.php?/archives/11-Implement-If-condition-in-SSIS-package.htmlhttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 9th, 2011 6:04pm

you probably have a package variable which has value ( 0 or 1 ), in the data flow task, before conditional split add a derived column transform and write this expression to create new column based on variable's value: @[User::MyVariable] note that you should use your variable name instead of MyVariable. name the output column as FlagColumn then in conditional split use this expression: [FlagColumn]==0 name this output as TxtOutput and name default output as ExcelOutput after the conditional split connect TxtOutput to multicast, and then connect two output from multi cast to two txt destination and connect ExcelOutput to excel destinationhttp://www.rad.pasfu.com
November 10th, 2011 1:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics