Hi,

Thankyou all for your replies. I have imported the file into a seperate table and have noted the error.

It would appear that carriage returns are causing the issue, this then impacts on the alignment of the fields. I'll will have to complete some further investigation.

One additional question... Is there a way when importing records using DTS to capture the line that the process fails on?.

Many thanks for your assistance.