SQLTeam.com | Weblogs | Forums

RESOLVED - SSIS Cannot convert between unicode and non-unicode data type

I'm exporting a SQL table to Excel. It fails on the first column which is varchar(50) in the table

Error: Cannot convert between unicode and non- unicode data type.
I can't find where I could change DT_WSTR to DT_STR or visa versa.
But I changed the data type in the table from varchar to nvarchar. Still get the same error.
Thanks.

RESOLVED - I just needed to Refresh the Data Source after I changed the data type in the table.