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

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