missing records with DTS import flat file

[lyudmila]

Hi all,
When I import client flat file to SQL Server using DTS, I have no errors, but my table missing 300 records. It's simple import using "data import wizard". I found few records in file, that missing in my table, and try to analyze it. We have UltraEdit tool, but I'm new to file editing. I do not see any unprintable characters in ASCII mode and I'm not familiar with HEX mode. Where can I get information on hex file format and how to look for characters that MS SQL Server truncating. Please help!

 

[MAK9974]

it happend to me too.

I changed my DTS in such a way that i import to a table with single column and then do the cleanup and then migrate that to the original table.

 

[esdee]

are you sure that the target table is 'missing' records from the original table?
if your source table is on a heavy OLTP it could be that in the moment of transfering the data many new records appeared in the source that could make your record calculations wrong ?