|
Home > Archive > MS SQL Server DTS > January 2006 > variable number of columns excel files to load
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
variable number of columns excel files to load
|
|
|
| Hi,
I need to load some excel files but they don't have the same number of
columns, I know which one has the max amount of columns and I created a
table that has enough columns to handle this one,
Problem is when I try to load them I get an error, how can I have dts to
automatically remap the columns when I change the source file for the excel
connection?
--Ilann
| |
| Allan Mitchell 2006-01-21, 7:23 am |
| Hello Ilann,
Don't you wish this was easier than it is?
You have to basically rebuild in code all the transformations yourself.
There is no way to just point one datapump between Excel and SQL Server at
any given number of Excel files of differing structures and have the pump
reconfigure itself.
What is probably happening here is that the datapump is looking for attributes
in the SourceColumns property of the transform and cannot find them.
I have an example of some auto remapping in a package if you ping me offline
Allan
> Hi,
>
> I need to load some excel files but they don't have the same number of
> columns, I know which one has the max amount of columns and I created
> a table that has enough columns to handle this one,
>
> Problem is when I try to load them I get an error, how can I have dts
> to automatically remap the columns when I change the source file for
> the excel connection?
>
> --Ilann
>
|
|
|
|
|