Posted by jhofmeyr on 01/04/08 13:51

Hi Stephen,

No, SSIS can't map columns automatically unless the names are the
same.

Why aren't the names the same? If you're transforming your data, you
can rename your columns. Or your connection manager could assign the
correct column names and you can ignore the names supplied by the file
(if that is why they are different).

It would be just as frustrating if columns *were* automatically mapped
by position for those who do not want this behaviour as it is now for
those who do :)

J

[Back to original message]