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?
Thanks
Our community of experts have been thoroughly vetted for their expertise and industry experience.
This award recognizes a member of Experts Exchange who has made outstanding contributions to the community within their first year as an expert. The Rookie of the Year is awarded to a new expert who has the highest number of quality contributions.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.