SQL Server 2008: BULK INSERT csv - is it possible to choose fields?

Question

I am doing:

BULK INSERT CSVTest FROM 'c:\csvtest.txt'
WITH
(FIELDTERMINATOR = ',',
 ROWTERMINATOR = '\n')
GO

--Check the content of the table.
SELECT *
FROM CSVTest
GO

--Drop the table to clean up database.
SELECT *
FROM CSVTest
GO

Is it possible to insert only specific fields FROM the csv?

Answer 1

You can do this using a format file. See: Using a Format File to Skip a Table Column and Using a Format File to Skip a Data Field.

Answer 2

Alternatively, you can bulk insert into a view.

See also this question.