>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

Look in the middle of this blog post

http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/title-12/