Select all source and dest cols in SSIS -
11-03-2006
, 11:55 PM
The old 2000 DTS had very simple options for copying "All Colums"
during a flat file import. I don't see anything like it in SSIS. A
couple of clicks in the old DTS designer and you were done.
For SSIS, if you have 200 cols in the source file that match 200 cols
in the destination table, is there a simple way to do the old select
all for source and destination objects? It appears I have to select
each source/dest column again in the dataflow task.
Ken |