for each loop problem

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  November 7, 2011 at 2:41 pm

  #259640

  Hi

  How can I loop through a column using for each loop container...or in SSIS

  I have a column Level with values 1 then 2 then 3 then...go on...

  I want to run my DFT for each value of Level....

  Thanks

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]

• christina-518819

  SSC Enthusiast

  Points: 121

  More actions

  November 8, 2011 at 5:00 am

  #1404370

  You could use an execute sql task to select distinct values from that column, write the results to an object variable and loop over that in your container.