Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jsolomon
Starting Member
13 Posts |
 Posted - 2011-02-16 : 08:14:06
|
| Ok, I have used ssis to import csv, piped,tab and dbf files. Now they hand me a .txt file with fixed columns. No delimiters. My table has 24 columns and the txt files has 58. I need to import about 19 columns from the text file in different places and order than my table. I have read the book online and every post on this forum (I think). Just not sure how or what the best method is. One is bulk insert with a format file or bulk insert to a temp table then parse the into production table. I have not really found any good examples of importing fixed files using a format file and skiping columns. Any ideas??????Jeff |
|
|
|
|
|
Bulk insert fixed width text file