HI Mate,

No, I never found a solution to the problem I was experiencing, I do need to look into it again.

I was starting to think I might need to update my SQL Data Tools ( thinking the Import Wizard GUI might be the problem). When it runs, it opens the 2010 shell.. surely there has been update of the tools...

With regard to your problem, all I can think of is that perhaps the field you think you are inserting into contains an Identity data type ( auto incrementing ).

Good Luck.