Copy Activity Failing - BasePrimitiveConverter an invalid zoned decimal value was encountered.

Question

This copy activity has been running fine for at least a year and just started getting this error on 9/6/22
This is the full error message.
There are 3 packed decimal fields in this table. I have tried converting these fields to Decimal, to Char , etc and it is still failing.
ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Upload file failed at path raw/as400/RETURN\RETURN_2022-09-13T15:53:38.7300893Z.csv.,Source=Microsoft.DataTransfer.Common,''Type=Microsoft.HostIntegration.DrdaClient.DrdaException,Message=HISMPCB0015 In BasePrimitiveConverter an invalid zoned decimal value was encountered. SQLSTATE=HY000 SQLCODE=-343,Source=Microsoft.HostIntegration.Drda.Requester,'

Answer 1

I have actually figured out the issue. The issue was related to bad data in a field and was not related to the packed fields at all. I made a clone of my copy activity and commented out all of the columns in my query and ran them a few at a time to figure out which column was causing the issue. When I figured out which column was causing the problem, I reviewed the data and was able to spot the problem and fix the data. The error message was a little misleading.