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

Karthik Ponugoti 0 Reputation points
2024-01-23T15:31:37.07+00:00

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

User's image

OLEDB Destination:

User's image

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)

User's image

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

Regards,

Karthik.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 40,356 Reputation points
    2024-01-24T03:25:36.8066667+00:00

    Hi @Karthik Ponugoti, User's image

    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.

    0 comments No comments

  2. Tallapragada, Lakshmi Satya M 0 Reputation points
    2024-01-24T04:47:09.08+00:00

    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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.