Its a little old school I know. Ive used BCP since forever.. its always worked without fail.. until now.
I have data that prepares and exports to a text file on a network destination using BCP. Lately on somedays the file exports with a problem. The contents of the file looks Chinese. *Attachment: File Content*
If i open it up with MS word, its in a unicode format.. *Attachment: MSWord*
Why will it work perfectly 1 day and not the next?
If i manually export the exact same data through an SSIS package it works fine..
Thanx for reading.. 🙂