Jeet - that only works if the entire row is distinct, I suspect that it may be just the key that has the duplicates.

Simplest way I know to fix this...

I`d never used the FTP facility in a DTS, so I just went and had a go. I found that if I used ftp://ftp.whoever.com/ it gave the error message...

Hi Mark,

If the source field is consistently 8 digits, with 4 digits on either side of the point, I would import it as a Char and then add the point, something like.

SELECT...

Allen - I think he said 'UNION', but I suspect the same would apply IE

UNION

SELECT a.Field1 COLLATE SQL_Latin1_General_Cp1250_CS_AS 

FROM a

etc

Collations have been one of my biggest headaches over the...

Hi Russ,

Format file is defiantely the way to go, I`ve had great success importing all kinds of data files with them.

This is Not tested but your formatfile would look something...