Data Conversion for Excel

Correct the Unicode and non-unicode Characters

Unicode string [DT_WSTR] which is nvarchar

string [DT_STR] which is varchar

To resolve this , use Data converion to convert nvarchar to varchar avaiable in SSIS as shown as below