dbTalk Databases Forums  

SSIS Mapping Columns from Flat Files

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss SSIS Mapping Columns from Flat Files in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
stephen
 
Posts: n/a

Default SSIS Mapping Columns from Flat Files - 01-04-2008 , 03:49 AM






I had to use use ssis 2005 in a short project recently & had little
time to work it out. I was importing a whole bunch of flat files into
SQL Server tables with many derived columns and transformations in
between.

It seems to automatically map columns from the flat file to columns in
the sql table where the names of the columns are equal. But can it
also do it automatically on position, so flat file column 1 goes to
sql table colum 1, etc, etc? In each flat file I had to manually click
and drag the columns across to map them which took a very long time as
there were hundreds of columns in some tables!

Thanks.


Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 - 2008, Jelsoft Enterprises Ltd.