Si, devi usare l'opzione FORMATFILE in cui gli indichi un file di esempio (che ha in formato che tu vuoi)
Guarda questo esempio:


create a test file C:\test.txt using this simple line of text aaaabbbbccccdddd repeated 2405699 times

run osql.exe against the sql server and execute this statement on the test database

create table t( a char(4), B char(4), C char(4), D char(4) )

then save file C:\test.fmt with the following content:

8.0
4
1 SQLCHAR 0 4 "" 1 a Latin1_General_CI_AI
2 SQLCHAR 0 4 "" 2 b Latin1_General_CI_AI
3 SQLCHAR 0 4 "" 3 c Latin1_General_CI_AI
4 SQLCHAR 0 4 "" 4 d Latin1_General_CI_AI

and then execute bulk insert statement like this:

bulk insert t from 'C:\test.txt'
with ( FORMATFILE = 'C:\test.fmt', BATCHSIZE = 10000 )

L'ho preso da qui: http://www.experts-exchange.com/Data..._20847182.html