Why don't you just set the SSIS package to redirect the error rows in the data flow and dump them back out to a table or file to determine which row's the culprit?

For both Unicode (UTF-8) and ASCII, 0 is defined as "NUL", which looks like a non-display character that's used as a terminator of some sort, so I'm sure it would cause issues with display...