I am setting up a package that exports a table to an Excel spreadsheet. The columns are NVARCHAR(50) in the table.
When I set up a one to one column mapping betweeen the two, the step errors out. Message is Column "ServerName" cannot convert between unicode and non-unicode string data types.
What am I missing?
Any assistance is apprecriated.