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