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
- #Dyn365CE2020.05.29Using Data Anonymizer component (SSIS) to mask data in Dynamics 365
- #Dyn365CE2020.05.27Different ways of getting record count (total) in Dynamics 365
- #Dyn365CE2020.05.26Planning to show a custom multi-select lookup. Use the Xrm.Utility.lookupObjects to show a multi-select lookup control in Dynamics 365
- #Dyn365CE2020.05.26Using Data Spawner component (SSIS) to generate sample data in Dynamics 365