UNICODE Conversion in Excel
I'm working in the Exporting to Excel section of chapter 8. I'm not using the AdventureWorks database, but rather the reporting database here at work.
When I run the package, I get the following error:
'Error at Data Flow Task [Excel Destination ]: Column "status" cannot convert between unicode and non-unicode string data types.' This message repeats for all string type fields. I've gone so far as to try the data conversion transformation.
Any help would be appreciated.