I am trying to map some fields from a SQL query (using the Single Value Mapping Component) to the fields I created in a user defined data type (made in Type Designer).
I am having a problem with a field that contains a cost. In the original database, the variable type is a "double", but when I debug, I keep getting a "Field Mapping Issue", even though I have tried almost all the different number formats available for the field in the User Defined Type.
How could I go about troubleshooting this issue further? Thanks!