Dropped Records using DTS

[Kay]

Hello everyone,

Hope someone may have a suggestion for an issue I'm facing with DTS.

I'm trying to import data in a .txt file format (has about 18625 records) to my staging table in SQL Server. The DTS process went through fine until I did a count of the number of records in my staging table. I found 52 records dropped during the process. Repeated the process to find the same 52 records dropped. The data is fine in the text file.

Does anyone have any idea what I may need to change? Or why this may be occuring?

Thank you,
Kay

[skhanal]

Are these 52 records at the end of text file?.

Do you get any error message?

Save the dts package and change its properties create error log. That might tell you something.

[Kay]

Hi skhanal,

Thanks fro ur reply.
No the 52 records are not at the end of the file.

The DTS package mysteriously also does not raise any errors in my Error file. Still no idea what's going on.

Kay

[skhanal]

Open your text file and see if you are missing row delimiter (carriage return and line feed or whatever delimiter you are using) at the end of some rows (may be 52)