Hi Martin,

Try to load the file into a temporary or a stage table with a varchar datatype for the datetime column and then load into the final table with conversion...

Thanks!

It works as intended.

/Martin

Hi

To find duplicate ( or even more than duplicates ) try this

select

field1,

field2,

count(*)

from table

group by

field1,

field2

having count(*)>1

where field1, field2 are the fields that will be checked for duplicates.