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."