The SSIS packages has no validation/execution errors when developers run from their machines. When the project was deployed to development server, and run a validation there are a lot of conversion errors the package has sql to oracle connections.
Error:
"Copy of Column name cannot convert between Unicode and non-Unicode string data types"
Data Flow Task:Error: "OLE DB Destination" failed validation and returned validation status "VS_ISBROKEN".
What is the reason for these errors.
Many thanks!