Hi

I'm trying to export some data from SQl tables to Excel.

I've got a data flow task with an oledb source but I keep getting an error.

[OLE DB Source [1]] Error: Column cannot convert between unicode and non-unicode string data types.


Any ideas on how I stop getting this problem

Thnaks

Nick