I have a large text file (3.5GB) that I need to import. Each record is
terminated with a CR/LF. However, the length of each record varies (60
characters to 79 characters). The last field in each record is a name field
that is not padded with blanks at the end.

My different attempts to copy this with DTS (to another flat file, db, etc)
have not worked.

Does anyone have a solution that they would please share with me?

Thanks.

Mike.

MikeV06 wrote:
In your Filesource Connection choose 'Delimited' (not'Fixed Fields')
checkbox,choose {CR}{LF} like Row delimiter,click Next and select a
column separator if exists.

Try it

Bye

On 12 Jul 2006 12:30:53 -0700, Davide wrote:

I had done that, but I had not used {CR}{LF} as a column delimited so that
I was importing a single column. Without doing that, the system gets
confused. I then used VBScript transformations to copy the single column
(with mid) to the appropriate fields.

Thanks.