I am getting this error message after the package runs for a few minutes.
0x80004005 Description: "Invalid character value for cast specification.".
The script in my package has many lines like this:
,cast(RTRIM(LTRIM(d.ACTNUMST)) as nvarchar(35)) as AccountString
All the conversions are trying to strip away blanks. They are all nvarchar and there no conversions to float or int. I have tried looking for blanks in my database and there are plenty of them but that should not cause this error. How can I track down exactly which row is causing this error so I can root out the bad data?