Not able to map DT_I4 to DT_WSTR

votes

Kaushal Kumar posted this 08 August 2020

posted 08 August 2020

While importing, whenever I try to map an integer field from SQL to string field in Salesforce, system says invalid type map.

salesforce sql-server data-type

3 Comments

Order By: Standard | Newest | Votes

votes

Mariia Zaharova posted this 08 August 2020

posted 08 August 2020

Admin

Hello Kaushal,

Thank you for contacting our Skyvia Team!

You can try map such fields via Expression mapping in the following way:

(DT_WSTR, 10)i4_field

where 10 is the length of the string (use the corresponding to your scenario value here), i4_field is your integer field.

Please tell us if this helps.

Best regards,

Mariia

votes

Kaushal Kumar posted this 10 August 2020

posted 10 August 2020

Hi Mariia,

I tried doing it but it is not showing the option of 'Expression' under 'External ID' and 'Target Lookup'

votes

Mariia Zaharova posted this 10 August 2020

posted 10 August 2020

Admin

Hello Kaushal,

Thank you for your reply.

Expression mapping is available as a separate mapping type. Expressions cannot be used in the Lookup or External Id mapping.

Best regards,

Mariia