Finding Hidden Characters in Data Files

Often a hidden character in an ASCII data file can cause problems when trying to use bcp. This problem often results in an "unexpected null found" error message. The hidden character can usually be found at the bottom of the file. Many utilities and text editors display hidden characters. Finding and removing this character should resolve the problem.