April 26, 2011 at 12:59 pm
I have a SSIS Package that exports data from an Excel file to Sql Server
Now, I would like to read a table with multiple file name and file path to fire a data transformation flow that will load this files in their Xdirectories in its aproppiated table, I have setup a SQL task that query the table and pass it (via variables) to a Foreach Loop container but it appears that does not pass their variable names to the excel connection manager (or the excel connection manager can't read variables) and always explode it here,
Is it an viable scenario or I'm doing something wrong ?
All these files have the same struct and I'm trying to use an enumerator ADO Foreach.
Note: I'have used File enumerator Foreach which works perfectly but this scenario include read a table with filenames and filepaths.
Thanks in advance for any idea
April 27, 2011 at 4:00 am
If all the Excel files have the exact same structure (also equal sheetnames), than it is a viable scenario.
To configure the Excel Connection Manager dynamically, you need to construct the filepath to the Excel file in the connection string using properties.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply