Importing text-files with various numbers of columns 2

[psychodad71]

I'd like to import various text-files with various numbers of columns to existing tables. The problem seems to be that the the text-file for example contains 250 columns while the table contains 260 columns. The source columns should be copied to the first columns of the destination table.

source - destination

col001 - a (col001)
col002 - b (col002)
.... - .....
col250 - xyz (col250)

My first attempt is to create an activex-script which deletes all existing transformations and create new transformations. The problem is to connect all source columns to the first columns of the destination table. Any ideas ?

 

[nigelrivett]

This is aimple using bulk insert.
Have a look at

http://www.nigelrivett.net/BCP_quoted_CSV_Format_file.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[nigelrivett]

and

http://www.nigelrivett.net/ImportTextFiles.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.