Cannot convert between unicode and non-unicode string data types error in SSIS – Nishant Rana’s Weblog
While using the OLE DB Source component in SSIS, on updating its SQL Command we started getting the below error for “Phone” column in our Table.
The fix is to open the Advanced Editor for the OLE DB Source component
Change the Data Type (non-unicode string) for the Phone column inside Output Columns in Input and Output Properties Tab.
Changing the Data Type from Unicode string [DT_WSTR] to string [DT_STR] fixed the issue.
Hope it helps..
Continue Reading Nishant Rana’s Article on their blog
Cannot convert between unicode and non-unicode string data types error in SSIS – Nishant Rana’s Weblog
Blog Syndicated with Nishant Rana’s Permission
More About This Author
Array
- Dyn365CE30 April 2024Use Geolocation Settings for Location Tracking and Auditing – Dynamics 365 Field Service
- Dyn365CE29 April 2024Fix the trigger – Microsoft.OData.ODataException: A binary operator with incompatible types was detected. Found operand types ‘Edm.Guid’ and ‘Edm.String’ for operator kind ‘Equal’ (Power Automate / Dataverse)
- Dyn365CE23 April 2024Portal does not load and displays “Server Error” or shows “Getting set up.. This might take a while” message -Portal Startup Issue (PowerApps Portal)
- Dyn365CE22 April 2024Versioning and Drafts for Solution-based Cloud Flows – Power Automate