dbTalk Databases Forums  

Select all source and dest cols in SSIS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Select all source and dest cols in SSIS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ken
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.