dataflow task in for loop container

• radha.subrayan-1095437

  SSC Enthusiast

  Points: 112

  More actions

  October 23, 2009 at 10:04 am

  #136635

  Hi,

  I am new to SSIS.

  I have a requirement of creating a package which takes the time key as the input and update the fact table with new data for each time key.

  For this,

  1.I created a variable Time_key as int32.

  2.I created a For loop container which contains

  InitExpression :@Time_key=134

  EvalExpression:@Time_key>=143

  AssignExpression:@Time_key+1

  3.Inside the for loop container,I created a dataflow task

  which uses Ole db source which has query as

  select * from fact

  where time_key=?

  with parameter as user::Time_key

  But when I run execute the container ,the variable is not passing values to the dataflow task.

  Please let me know whether this approach is correct.

  Thanks,

  Radha.

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  October 25, 2009 at 7:24 am

  #1070433

  You have to have:

  EvalExpression:@Time_key<=143

  I don't think the for loop container will execute at all. Otherwise I think the approach you have is correct.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/