What is the solution to fix this issue ? I working on an assignment (SSIS) and I cannot seem to figure the issue

Boymzii 0 Reputation points
2023-05-10T06:21:24.56+00:00

WhatsApp Image 2023-05-09 at 20.33.11

WhatsApp Image 2023-05-09 at 20.34.00

WhatsApp Image 2023-05-09 at 20.32.10

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,113 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,492 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,571 Reputation points
    2023-05-10T07:07:58.1466667+00:00

    Columns "Company" and "CompanyName" cannot convert between unicode and non-unicode string data types

    As the error message clearly says, the data type of source & destination columns must match exactly, otherwise you have to convert the data implicit, e.g. using "Derived Column", see

    https://learn.microsoft.com/en-us/sql/integration-services/data-flow/transformations/derived-column-transformation?view=sql-server-ver16

    0 comments No comments

  2. ZoeHui-MSFT 34,581 Reputation points
    2023-05-10T07:59:30.9033333+00:00

    Hi @Boymzii,

    It is a data convert issue.

    We will cover 5 solutions to handle this issue:

    1. Using a Data Conversion Transformation
    2. Using a Derived Column Transformation
    3. Converting the Data Type Implicitly in the Data Source Component
    4. Using a Script Component
    5. Converting the Data Type Explicitly in the Data Source Component

    You may take a reference below.

    Fixing Cannot Convert Between Unicode and Non-Unicode String Data Types in SSIS

    Regards´╝î

    Zoe Hui


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