Unable to cast Big INT value to String

  • 23Views
  • Last Post 21 March 2018
0
votes
Marina Seredova posted this 21 March 2018

We have an import job which will pull data from SQL server to Salesforce   

The data in one field is of type BIGINT in SQL server and we want to store it in a field of type String.

We are trying to cast it as (DT_WSTR)ID but it is throwing error as below

"Attempt to parse the expression "(DT_WSTR)ID" failed. The expression might contain an invalid token, an incomplete token, or an invalid element. It might not be well-formed, or might be missing part of a required element such as a parenthesis."

0
votes
Mariia Zaharova posted this 21 March 2018

You should use an Expression mapping in this format:

(DT_WSTR, 30) ID

where 30 is the length of the string (set here the value that is suitable for your scenario).

 

Please refer to:

https://skyvia.com/resources/docs/index.html?data_types_and_limitations.htm

https://skyvia.com/resources/docs/index.html?expressions.htm

 

Please tell us if this helps.

Close