sql server NVARCHAR

knowledge · Post by **knowledge** » 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,

ray.wurlod · Post by **ray.wurlod** » Wed Jul 20, 2011 3:48 pm

Try using ODBC stage for SQL Server.

chulett · Post by **chulett** » Wed Jul 20, 2011 3:48 pm

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

knowledge · Post by **knowledge** » 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...

samunik · Post by **samunik** » 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.