• I'm using SQL2012 and following your steps as carefully as possible.

    I have copy and paste your example code and data.

    When I run the BULK INSERT in Studio the result is error 'Cannot bulk load. Invalid column number in the format file...'

    I have googled for more info but no-one seems to have an answer that makes sense to me.

    Suggestions?