Note: This is an old article, citing an issue with legacy systems or providers. Some troubleshooting tips may still be applicable to newer versions. However, this article has not been tested with newer releases after 2016.
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.