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 |
|
govindts
Starting Member
33 Posts |
 Posted - 2008-02-24 : 10:41:37
|
| All,I am developing the SSIS pacakge. I am loading the data from excel file to Sqlserver table. I have two set of excel files and each excel file belongs to one division. I want the same mapping should call both file. Basically, i wanted to pass the filename as a parameter. Any help....RegardsGovind |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-24 : 12:09:04
|
| You can put the excel files onto a folder and use a For each loop task's for each file enumerator object and map it to the folder so that it takes each excel file in turn and does the transfer. Please ensure the structure (metadata) of both files are the same.[url]http://blogs.conchango.com/jamiethomson/archive/2005/05/30/SSIS_3A00_-Enumerating-files-in-a-Foreach-loop.aspx[/url][url]http://www.sqlis.com/55.aspx[/url] |
 |
|
|
|
|
|
passing excel file as a parameter