I am new to DTS and hope someone can help.

I have a Text file source that is used to read in records from a text file.

The records have fix length fields with a CR/LF at the end of each record.

The problem I have is that when I attempt to use the Data Pump to transform these records into a SQL table, I lose some of the records.

The reason appears to be due to the fact that the source file truncates the record if the last fields are blank, and the length is variable.

The Data Pump does not appear to like this and when a record of this type is found, the system appends the following record into the current record, causing a concatination of the records.

Any Ideas on how to solve this?

Thanks in advance