I've got a table with 3 columns, ID, CourseID, CourseTitle. I have a CSV File that has CourseID and Course title in it. This is being inserted into table "Course." In this table I have ID set to 'isEntity' so it auto generates. How do I go about inserting the data into the table and ignoring the ID column? Right now I'm getting an error saying
"Bulk load data conversion error(type mismatch or invalid character for specified codepage) row1 column 2 (ID).
BULK INSERT Course
FROM 'E:\CourseCSV.csv'
WITH
(
FIRSTROW = 1,
FIELDTERMINATOR = ',', --CSV field delimiter
ROWTERMINATOR = '\n', --Use to shift the control to next row
TABLOCK
)