Data Services All Products
The mapping fails when the SQL query override has decimal 38 column specified and high precision mode is enabled.
When you import a flat file with high precision in the Developer tool or the Analyst tool, the data is rounded using a scale of 16. If the data has a scale greater than 16, it is rounded using a scale of 16 and the remaining scale is 0.
When an unconnected Lookup transformation contains an SQL query override for the Decimal port with a precision of 38 digits, the Data Integration Service incorrectly converts the decimal value.