Follow

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

Symptoms

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.

Cause

There is a problem with the Unicode conversion.

Resolution

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
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.