|
Posted by JCC on 10/31/06 08:56
Hi all
Could someone help me with the following problem? Hours of googling
yesterday couldn't get me the answer. I'm using SQL 2000 and DTS and
trying to import a huge fixed width text file.
File is >1m rows and >200 columns and is defined by a proprietory (i.e. not
bcp produced) format specification of the form
Name Start Length
Fld1 0 20
Fld2 19 5
Fld3 24 53
and so on.
Tbe only way I've found to define the columns so that DTS can import the
file properly is to go through the wizard and click on the starts of each
column. I don't want to use bcp if possible (I did enough of that on
SQL7) - but surely there's a way to get DTS to read from a format file so I
don't have to click 200 times (with all the ensuing errors I could make).
Any help greatly appreciated.
Cheers
Rob
Navigation:
[Reply to this message]
|