Error: "Error creating DTS package for Oracle_AD_USER. Unable to validate the structure of the SSIS package."


With an Oracle database as a data source, you get an error like the following while deploying:

Error creating DTS package for Oracle_AD_USER
Unable to validate the structure of the SSIS package. Oracle_AD_USER
SSIS Package: Oracle_AD_USER
Column "CONNECTIONPROFILE" cannot convert between unicode and non-unicode string data types.


There is a problem with the Unicode conversion.


Change the Unicode conversion property on the data source in TX to Force-to-Unicode. Remember to synchronize the data source for the changes to have effect.

This article applies to: timeXtender 4.5, tX2012, TX2014. Last updated: 2014-03-28.

Was this article helpful?
0 out of 0 found this helpful


Please sign in to leave a comment.