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 |
|
bvanyangu
Starting Member
20 Posts |
 Posted - 2014-04-02 : 00:39:59
|
| I have a situation where I want to load the Excel file dynamically, and the excel file have different columns or even worksheet name. Any idea how I could approach this? I believe there's no way to modify the meta data (specifically the mapping) in the data flow. |
|
|
sqlsaga
Yak Posting Veteran
93 Posts |
Posted - 2014-04-02 : 17:52:29
|
| Yes there is no way you can modify the metadata automatically, especially if the column names keep changing. It's okay if the file name changes but if the column names keeps changing the mappings doesn't happen and eventually leading to a package failure..Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles. |
 |
|
|
|
|
|
help pliz