Sql Server 2005 Text Data type Issue

[dspradeep]

Hi,

We are facing issue with

Code: Select all

 TEXT datatype 

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.

[ArndW]

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.?

[dspradeep]

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.

[chulett]

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.