|
|
Posted by Dan Guzman on 01/10/08 13:17
If this feature is important to you, consider submitting this feature
request via Connect feedback (http://connect.microsoft.com/sqlserver).
Perhaps it will make it into a future SQL version.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"stephen" <m0604955@googlemail.com> wrote in message
news:ac0a0ea9-4d43-43c4-b073-7fcf4351bbf2@f10g2000hsf.googlegroups.com...
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]
|