DSXchange

Hi,

We are facing issue with while importing this field then it is coming like LongVarchar then i have modified the sql query with cast(fieldname,varchar(8000)) then it is working fine but if the data contain more than 8000 then how can i read. That is the problem which we are facing now.

My Job Design is
-------------------------
Sqlsever stage --> copystage-->Seq file

I belive there is some way.... pls any one faced same issue and resolved exp.. then pls share it.

Would splitting into multiple columns work for you, i.e. cast(SUBSTR(TextField,1,8000),VarChar(8000)) then cast(SUBSTR(TextField,8001,8000),VarChar(8000)), etc.?

Thanks man , this is already in my mind but i thought worst case we can go this one. so i think no otherway i need to go that way only. let us see any other persons did in some other way also.

There is no other way. 'Large Object' Field types like BLOB or TEXT fields are simply not supported. Move / process them with whatever native tools your database provides.