Have you considered using INSERT ... SELECT * FROM OPENROWSET(BULK instead of BULK INSERT?
you can specify the columns to be inserted to with this command.
e.g.
INSERT testAll.[dbo].[branch](branch_code, branch_name, branch_desc)
SELECT * FROM OPENROWSET(BULK 'C:\myBranches.dat', SINGLE_BLOB) a
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”