I want to import a csv file into a sql server 2008 R2 database table using bcp using a command like this:
bcp Database..TableName in TableName.csv -n -T -E -S localhost
My problem: the table contains one row which is also in the csv file (default row inserted on creation of the database).
Can I somehow instruct bcp to ignore this line? I tried -m for max error count, but bcp still aborts when it hits the already existing record (primary key).
I can't just delete this record, since it contains installation-dependend information I'll need later on.