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

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.

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