Forum Discussion
Bulk Insert causing duplicates in target table
We use ETL tool(C# based) which uses Bulkcopy method to do bulk insert to target table. Recently we are facing 2 Issues in our daily loads 1. Target table with no primary key - the load returns ...
1. Target table with no primary key
that's already the main failure.
It loads same records 5 times.
You didn't provide any detail about your ETL process/tool, source data etc., so how could we guess?
DBA Team is unable to find anything in there logs
Of course not, why should SQL Server log simple DML operations on it's own?
You have to dig depper into it on your own and provide much more informations for us.
