I am using bulk insert to insert records from a flat pipe delimited file to a table. Here is the script I am using:
BULK INSERT
MyTable
FROM
'c:\MyFile.txt'
WITH
(
FIELDTERMINATOR = '|'
, ROWTERMINATOR = '|\n'
, FIRSTROW = 2
)
I have two questions:
First, is there a way to avoid the rows being index based? Is there way to use the column header to determine what field the element belongs in, instead of just skipping the row like I am in the example?
Second (and this might be related to the first question), is there a way to include an auto-incrementing PK field?