Importing data from text file to specific columns using BULK INSERT
- by Dinesh Asanka
Bulk insert is much faster than using other techniques such
as SSIS. However, when you are using bulk insert you can’t insert to specific
columns. If, for example, there are five columns in a table you should have
five values for each record in the text file you are importing from.
This is an issue when you are expecting default values to be…