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

Transact-SQL
1

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.

2

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