Deploying an Oracle table results in an 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.
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.
Select the Force Unicode conversion in the Oracle data source options, then re-synchronize the Oracle data source.
Author: Doug Wynkoop