Not a bad suggestion which I might try next. I came across this article which might address a solution. It looks promising. I'll post update if this works or not....

I checked those settings and already had SET QUOTED_IDENTIFER check boxed. I added this SET command at the top of the script and it executed in SQL Server Agent. Thank...

In your dataflow right click your OLE DB Destination and click properties.

In your Properties pane which might be on the right side.

Under Custom Properties there...

The error is because you need to specify your decimal better. When your looking at the decimal data type it is decimal(TotalPositions, RoundToThe) which is probably causing your issue. So...