Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m frustrated

Mismatch type or precision using lookup in SSIS

I'm working in SSIS and trying to perform a lookup to ensure that the data I am going to update is indeed different than the data that already exists. I am encountering a problem when I try to compare a currency that exists with a scale of 4 and a precision of 18.

When I look at the column coming from Salesforce it is defined as a decimal but the number I am comparing to in the lookup can either be the same scale and precision but a numeric type or can be a decimal but I can't define precision.

Either way I can't then use the lookup to compare as it triggers an error that it either doesn't match in type or in precision. Any help would be appreciated.
1 person has
this problem