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" <m0******@googlemail.comwrote in message
news:ac**********************************@f10g2000 hsf.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.