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 TimeXtender’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