Imagine if we have a table "Names" that has these fields:
ID (int, PK, Identity Seed)
Imagine a CSV having just 2 columns of the 3 above:
how would I use BCP utility to tell it to insert each row where the row has a new line as a terminator for the row to be inserted? The ID in the table needs to be there for obvious reasons and the import file will not have this.
I tried this but it did not quite work. Data does not insert correctly.
bcp Names in C:\DataInput.csv -S . -d TestDB -q -c -t "," -T -r \r