DTS Import Fixed length cutting off data

[bmacbmac]

Hello,

In SQL 2000 I am trying to import a text file. The first half of the text file contains lines that are 54 characters long.
The next 50,000 rows are 59 characters long and the last 25,000 rows are 67 characters long.

When running a DTS import with fixed length, it only imports the first 54 characters. The first section of the text file comes in, but the remaining lines are cut off.

Is there a way I can set the fixed length to 67 when starting the import? The 'red line' at the end of the 59 character rows is permanent and does not allow me to move it.

Thanks!

Brian

 

[simian101]

Fixed length is normally all the same length.

You could serperate the file in to 3 files to accomodate the different lengths.

Simi