I want to Import several delimited text files into SQL Server using DTS. If i am not using any Index on the table, my program work fine but if i use primary index, on the very first violation of the index DTS Rollbacks all the imported data and thus in effect importing no data at all.
How can i eliminate this?
I want to import million records at a time that may contain duplicate records too and i want to skip duplicate records while importing records in one go.
I don't want to use temporary tables in this process.