• 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”