Data conversion usage of SSIS

When the SSIS error is: "Cannot convert between Unicode and non-Unicode string data types", consider implementing it with a data converter, as simple as:

The first step is to find the data converter:

The second step is to edit the data converter:

The third step: Edit the target mapping relationship is "copy of XXX", you can.

Error exclusion, success.

Note: The data Connection Manager for SSIS is best used for SQL Server authentication, which guarantees the proper execution of agent jobs and, of course, the ability to set sufficient permissions for Windows authenticated accounts.

Data conversion usage of SSIS