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

Question

Answer 1

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

Answer 2

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.