Can you post the table definitions including collation for character columns?

If your import table has a case-sensitive collation and your destination table does not you could still get duplicates with all the solutions provided already.

Fixed-length vs. variable length could potentially be an issue here as well.