Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Datatype convertion prob

Author  Topic 

siva.meti
Starting Member

32 Posts

Posted - 2007-12-04 : 09:52:37
Hi Friedns,



I am transfering data from oledb source to excel destination i am getting this error





error : First name cannot be converted unicode datatype to non-unique code datatype



any body plz help me





Thx

subu


Meti BEST OF THE BEST

nr
SQLTeam MVY

12543 Posts

Posted - 2007-12-04 : 10:57:26
Add a data conversion step to your data flow.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -