Unicode conversion failed
Posted: Mon Apr 23, 2012 12:18 pm
Hi All,
i have a DRS stage that is used for extracting data from sql server , couple of the columns are declared as nvarchar in the sql server database. i tried to define them as varchar and unicode as extended in the DRS stage but am receiving this error "[IBM(DataDirect OEM)][ODBC SQL Server Driver]Unicode conversion failed".
For a similar problem with another job i defined datatype as varchar and data element as Sql.guid and it worked but this time even this is not working.
can anyone please shed some light on this.
Thanks
i have a DRS stage that is used for extracting data from sql server , couple of the columns are declared as nvarchar in the sql server database. i tried to define them as varchar and unicode as extended in the DRS stage but am receiving this error "[IBM(DataDirect OEM)][ODBC SQL Server Driver]Unicode conversion failed".
For a similar problem with another job i defined datatype as varchar and data element as Sql.guid and it worked but this time even this is not working.
can anyone please shed some light on this.
Thanks