You can bulk insert into a temporary table and then select the columns you desire. Here is an example:

DECLARE @TempTable TABLE

(

Column1 INT,

Column2 VARCHAR(10),

Column2 VARCHAR(10)

)

BULK INSERT @TempTable FROM 'Filepath'

SELECT Column1, Column2

FROM @TempTable

As an alternative, I believe that you can use a format file to bulk insert directly into your desired table.