DSXchange

Posted: **Wed Jul 20, 2011 3:46 pm**

Hi ,

I am loading data from SQL Server 2008 to oracle ...One of the datatype is Nvarchar ...it is giving problem while loading into datastage ..I am using DRS stage for sql server ...

Please suggest ..

Thanks,

Posted: **Wed Jul 20, 2011 3:48 pm**

Try using ODBC stage for SQL Server.

Posted: **Wed Jul 20, 2011 3:48 pm**

Do we get any clues as to the nature of the problem?

Posted: **Wed Jul 20, 2011 10:09 pm**

Hi ,

It is giving out of range error ...I will post exact error tomorrow ...

Thanks for the reply...

Posted: **Thu Jul 21, 2011 4:48 am**

I believe with DRS you mean Dynamin RDMS stage. Dynamic RDMS has its limits with the size of the datatype. Please check what is the length of the NVARCHAR field. try defining it as long varchar or as ray suggested ODBC stage.

I too had a same problem trying to being BLOB datatype.

DSXchange

sql server NVARCHAR

sql server NVARCHAR