For each loop container where data comes from multiple columns in select from a SQL table
Posted on 2014-11-10
I need to create an SSIS package that will create files where the file name contains the Date and time of all rows that are selected from a SQL table. I gather that I need to use a foreach loop container, and I Have three variables that hold Dte: '1/2/2014' which is the date from the input table, Hr: 15 which contains the hour of the day and Portion: 1 or 2 which designates if the activity occurred in the first half hour (1) or the second half hour.
Do I need to generate a for each loop that for each Date then within that for each loop the hour of the day, then a third for each loop that designates the half hour or can I do I all in one For each loop?
Can someone give me an idea of how to proceed?