Error Message: Columns cannot convert between unicode and non-unicode string datatype
Action:
When I am executing a package that includes Lookup Plus Component I get the following error message:
Error Message:
Columns cannot convert between unicode and non-unicode string datatype
Solution:
To resolve this issue you need to set up the Lookup's output column DataType to string[DT_STR].
Please follow the steps:
1) Right click on the COZYROC Lookup Plus component and select Advanced Editor
2) Change the output column DataType to string[DT_STR] for the column in question.
Please see the screenshot below:
Book a Presales Call
Related Articles
Error Message: Columns cannot convert between unicode and non-unicode string datatype
Action: When I am executing a package that includes Lookup Plus Component I get the following error message: Error Message: Columns cannot convert between unicode and non-unicode string datatype Solution: To resolve this issue you need to set up the ...Error Message: Columns cannot convert between unicode and non-unicode string datatype
Action: When I am executing a package that includes Lookup Plus Component I get the following error message: Error Message: Columns cannot convert between unicode and non-unicode string datatype Solution: To resolve this issue you need to set up the ...Error Message: Columns cannot convert between unicode and non-unicode string datatype
Action: When I am executing a package that includes Lookup Plus Component I get the following error message: Error Message: Columns cannot convert between unicode and non-unicode string datatype Solution: To resolve this issue you need to set up the ...Match multiple columns with Lookup Plus
You can match multiple columns using the Lookup Plus component. See the steps below for one possible solution: Create a new data flow. This data flow will build a lookup reference dictionary and store it in a package variable. Insert a data flow ...How can I dynamically modify a transformation in an SSIS Data Flow Task?
COZYROC's Data Flow Task Plus allows you to dynamically modify source, destination and transformation components at runtime. For an overview and listing of properties for the following transformations, please check out the side menu item "Parameters" ...