|
|
Posted by stephen on 01/04/08 14:30
On Jan 4, 1:51 pm, jhofm...@googlemail.com wrote:
> 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
If i have to rename hundreds of columns from the flat file that would
take longer than doing the mappings manually. It seems that if I'm
importing a flat file into a table and there is a 1 to 1 relationship
between the columns ssis could easily map column 1 from the flat file
to map to column 1 from the table, etc, etc. For me, in most cases
this would be correct and it would take much less time to undo the
mappings I don't want than to have to manually map the ones I do want
(which in my recent project was 1000s of columns over almost 200
tables).
But I know this wouldn't apply to every scenario.
Navigation:
[Reply to this message]
|