I have a table with three fields, varchar(130), nvarchar(50), and int. The nvarchar field is the primary key.
Right now the database mdf file is 90GB. I have a text file that is 270GB with entries that need to be added to the database. BCP would work except that the text file creates primary key violations. I need a way to do this import. Ideally I would like a batch file. It can use BCP of any SQL scripts to do the job.
I need to run the batch file, have it execute, and import the 270GB of data into the DB. The primary key violations must be dealt with, and those records simply skipped.