SSIS Package: Error convert column between unicode and non-unicode string data types

Question

Hi,

We have an SSIS package that includes a data flow task to retrieve the data from the OLEDB source(SQL Server) using SQL command, goes through sorting to remove duplicates, and stores it in the OLEDB destination(Oracle DB).

OLEDB source output columns: Email_address(DT_WSTR), date inserted(dbtimestamp)

derived column component:

1. adds a new column and sets the static value to YES (DT_STR)
2. add a new column Email_address_non_unicode to convert DT_WSTR to DT_STR

OLEDB Destination:

When the package is executed on my local machine. It runs perfectly. But when it is deployed to a server, and run with an SQL agent job, the following errors are displayed (SQL agent job run by proxy account)

Does anyone have any idea on how to fix the issue?

Regards,

Karthik.

Answer 1

Hi @Karthik Ponugoti,

From the error message, it seems a data convert issue. Try to use Data Conversion to convert non-unicode to unicode. Regards， Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Try Converting , and VSI Broken error might be one of the columns is not mapped or refreshed , in the server. Teh structure difference between your local and server Please verify