executute data flow task using variable

• manser33

  SSC Veteran

  Points: 281

  More actions

  July 4, 2011 at 1:17 am

  #243474

  Hi All!

  if Is possible to run DFT using parameter from variable?... But not once, but several times from the LOOP.

  DFT know refresh the list of columns of a table?, and if you have an example?

• Ashok Teotia

  SSCrazy

  Points: 2407

  More actions

  July 4, 2011 at 2:44 am

  #1347673

  As per my understanding , You want to pass a variable to DFT and iterate DFT on the basis of that variable if i am right

  you can define a variable like counter set it initial value and then use this variable in for loop container like

  put values like this in FLC .. Initail Exapression: @counter==0

  EvalExpression:@counter<10

  AssignExpression:@counter=@counter + 2

  Regards

  Ashok