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

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

    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


    0 comments No comments

  2. ZoeHui-MSFT 34,581 Reputation points

    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


    Zoe Hui

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