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)
 Source destination error

Author  Topic 

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2008-03-04 : 02:30:43

Hi, I need help please!

I get the following error on my OLE DB Destination: column"Oprcode" cannot convert between unicode & non-unicode string data type.
Please Assist on what i should do!

Regards

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-04 : 03:02:00
CAST the column before inserting.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2008-03-04 : 06:17:59
Thank You

I done a data conversion on the data types as well as the lengths of the fields were not matching.

Thank You
Go to Top of Page
   

- Advertisement -