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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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:
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.
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.
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