I do a daily import of millions of rows so would prefer to use BULK INSERT.
I would like to import the csv files into a table with two extra columns not in the source files, but it seems as though BULK INSERT does not allow this. Are there any functions or properties of BULK INSERT that allow this.
It is imperative to use BULK INSERT over normal import as this reduces the import time from hours to minutes.
I've thought about importing into a temporary table on the SQL server db, and then moving this across to the actual table, but this also slows the daily import process quite considerably