I am building SSIS package where as initial step I am importing data from Excel (97-2003) Spreadsheet to SQL Server 2008 table. I got a Package Validation Error:
"Error at Data Flow Task [SQL Server Destination]: Column "VendorName" cannot convert between unicode and non-unicode string data types."
I made sure that data format in the spreadsheet columns match table columns but it did not resolve the problem. Any suggestions? Thank you.