• OK I seem to have identified the source of this issue...

    My destination table has more rows than my flat file and they are in a different order.

    I thought bcp was supposed to work when there was a different number of rows but it would appear that is only one sided...

    I have worked around this by implementing a staging table.

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------