Probably, you have an ID column, that is identity and you are not specifying it -and you can't- but because you don't specify which columns you want to load data into SQL tries to set them in internal column order.
Name your columns!
INSERT INTO MyTable (col1, col2) VALUES (1, 2)
and your problem will probably go away...