I think that the ADO.Net provider does an implicit conversion from varchar to nvarchar. If you need to use the ADO.net provider then you will need to convert the value back to varchar.

Is there any particular reason that you are using the ADO.net provider as your source instead of an OLEDB provider ? The OLEDB provider does not do this implicit conversion