Post reply

for each loop problem

  • 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]

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply