Example of : In SQL do s Bulk Import from CSV file.

Before you start your import of a CSV file into a SQL database, make sure the data in the CSV file and the Tables Columns are in the same order. Otherwise you'll get some interesting mismatching of information.

The SQL command you need is....

BULK INSERT TableName
FROM 'C:\Filename.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

One possible way to Bulk upload with a catch block.

BEGIN TRANSACTION
BEGIN TRY
BULK INSERT TableName
FROM 'C:\Path\Filename.csv'
WITH
(
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '\n',
    ROWS_PER_BATCH = 10000, 
    TABLOCK
)
COMMIT TRANSACTION
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
END CATCH