Not able to map DT_I4 to DT_WSTR

  • 9Views
  • Last Post 10 August 2020
0
votes
Kaushal Kumar posted this 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
Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 08 August 2020

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

0
votes
Kaushal Kumar posted this 10 August 2020

Hi Mariia,

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

 

0
votes
Mariia Zaharova posted this 10 August 2020

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

New Ticket
Categories
Popular Tags
Close