The package reads a table and inserts to excel.
The column LastName is defined as varchar(50)
In the SQL Command, I do a CAST for the LastName column as shown here:
CAST(Users.LastName as nvarchar(50)) as [LastName]
I also set the Database connection setting for "Delay Validation" to TRUE
So why am I still getting this error?
[Excel Destination ] Error: Column "LastName" cannot convert between unicode and non-unicode string data types.