Hi all,
I have a very weird problem.
I bcp data into 3 files, I merge the 3 files using copy /b and Bulk insert.
using the same data, this works under windows 7 but not under XP.
The error I get is: bulk load data conversion error (type mismatch or invalid character for the specified code page ...
Although I tried to use CODEPAGE RAW & ACP, I don't use any as it didn't make a difference.
I should mention that for testing purposes, I'm doing all 3 operations onto one same PC (XP for one and Windows 7 for the other)
Can some please enlighten me?
I definitely think that it's the Operating System?!?! but why?
I'm trying to understand...
Thanks
Go to the complete details ...