Follow

Error: Cannot convert the column data types Between Unicode and non-Unicode string.

Symptoms:  

Deploying an Oracle table results in an error message.

 

Error Message:

Error creating DTS package for <TableName>
Unable to validate the structure of the SSIS package. <TableName>
SSIS Package: <TableName>
Cannot convert the "<ColumnName>" column data types Between Unicode and non-Unicode string.

… [Additional “Cannot convert” lines may be present]

Error in validating "component" Data Source <Data Source> "(1)". Validation status "VS_ISBROKEN" was returned.

One or more components failed during validation. 
There were errors during task validation.

Underlying problem:

This error is the result of a clash between SQL and Oracle string data types. The error is thrown because the TX DWA’s default conversion into a SQL string could result in character loss.

 

Solution:

Select the Force Unicode conversion in the Oracle data source options, then re-synchronize the Oracle data source.

Return to Oracle Troubleshooting Hub

Author: Doug Wynkoop

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.