Hello!!
Please help to figuer out this error "The given value of type String from the data source cannot be converted to type nvarchar of the specified target column" while pulling data from source to stage.
Anyone Who Can Help!!!
Solved
converted to type nvarchar
Best answer by Syed Yousuf
As Trine has mentioned, use the Override Data Type feature. Review these guides:
For TimeXtender 6024.1 and later releases:
https://support.timextender.com/odx-107/using-the-override-data-type-feature-656
For legacy TimeXtender v.20 and earlier releases
Hi Rajneesh,
Sorry for a late response! Did you manage to solve the error?
If not, please respond to this message with a few more details, such as the source you are pulling data from.
The error message is indicating that a value being inserted or updated in your stage table is of type 'String' and cannot be converted to the type 'nvarchar' of the corresponding column in the table. The "nvarchar" data type is a Unicode string data type in SQL, which means it can store non-English characters. So the issue is that the string value is not compatible with the data type of the target column in the stage table. What you can try is to change the data type of your target column in the stage table to match the data type of the value being inserted or updated. You can check the source data type via the Data Source Explorer (right clicking your data source and click Data Source Explorer)
As Trine has mentioned, use the Override Data Type feature. Review these guides:
For TimeXtender 6024.1 and later releases:
https://support.timextender.com/odx-107/using-the-override-data-type-feature-656
For legacy TimeXtender v.20 and earlier releases
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
