I'm encountering an issue with data conversion in my SSIS (SQL Server Integration Services) package. When I execute the package manually, everything works fine. However, when I run it in an automated job, I encounter an error specifically related to converting from double float to numeric data types. This problem occurs specifically with values containing commas in my Excel data source The error message states: 'Conversion failed because the data value overflowed the type used by the data conversion transform'.
How can I address this error?