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
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
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" ...Error message: Retrieving the COM class factory with component with CLSID failed due to the following error: 80040154 Class not registered
Action: The following error is displaying in my Lookup Plus component. It appears right after I select my connection, and click the Table/View dropdown field. It appears again when I select the table/view. Error Message: Retrieving the COM class ...Setting up Salesforce Bulk Mode with COZYROC Script Salesforce Bulk Result Transformation
When using COZYROC Salesforce components in Bulk Mode the operations are asynchronous, meaning the results are not immediately available. If needed, the status, identifiers of newly created records, and any error information can be retrieved in an ...Where can I find the documentation for the Lookup Plus?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Lookup can be found at the following link. For many of the components you can find resources like an ...