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 |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2011-04-07 : 08:09:06
|
| Hi ,I get excel source files placed in a specific path which have to be loaded to SQL server tables. The excel files will have different number of columns with different column header and data.Is it possible to create a single package which dynamically creates table in the database based on the source file and loads into the newly created table.Thanks,Varalakshmi. |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-04-07 : 17:38:12
|
| SSIS script Task it. Grab excel name via variable, pass it as parm, in script grab excel file as object model then loop for columns, build dynamic script, run it in script or pass it back out as readable variable to run it as SQL script.If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
Dynamic table creation and loading