Code: Select all
Conversion error calling conversion routine decimal_from_string data may have been lost
Destination is a decimal(11,0)
I've tried several other datatypes and combinations. I've trimmed, I've substringed, I've null handled, I've done everything that I can think of and yet I can't get rid of this warning.
The data is flowing right, I can i live with the warning being in the logs, but I don't wan't to have this known warning count against me in my stats of jobs running ok.