A user on another forum suggested that I dump the error output into a text file.

I did this and I believe it has shed some light on the problem. It appears that the records that are failing have some unknown character in place of the apostrophe?

examples:

THAT?S

I?M

CAN?T

DIDN?T

These words appear as such in the actual source system:

THAT S

I M

CAN T

DIDN T

I have no idea how this happened.

So now that I have found the problem, how do i account for these unknown characters and ignore them so that the rest of the text comes over?