Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MrRichDean
Starting Member
1 Post |
 Posted - 2009-09-24 : 17:09:09
|
| Hello all - newbie here so be gentle!Ok, here is the situation. I have a number of files with weekly sales information:Sales1.xlsSales2.xlsSales3.xlsEach of these have identical data sets and I have succeeded in creating a foreach loop container..lovely stuff!However, each of these weekly reports have slightly different sheet names:Sales1.xls >>> Wk1Sales2.xls >>> Wk2Sales3.xls >>> Wk3Now this poses a problem with the forloop each container.I attempted to created a variable based on the worksheet name and change the excel file so that it looks at the table with varible and selected that worksheet variable.However, when I attempt to run this, it runs through the first file, executes that data flow but then fails when it encounters the second file.Has anyone got any ideas how I can sort this and/or a step by step procedure to complete this action?Apologies for being thick and any help gratefully received. |
|
|
|
|
|
Excel Loopeach Container - Different Worksheets