How can i handle large size in Datastage serveredition 7.1

mohandl · Post by **mohandl** » Fri Feb 15, 2008 3:06 am

My source is Sql server 2000,In one table for one column lengrth Text (16) this column i have to load in to traget table (My target is also SQL server 2000)

I am gettinr error like "Maximumsize of length truncated"

ray.wurlod · Post by **ray.wurlod** » Fri Feb 15, 2008 4:31 am

Experiment with VarChar and LongVarChar data types rather than Text.

mohandl · Post by **mohandl** » Fri Feb 15, 2008 5:49 am

I tried with Longvarchar ,But no use (same error i am getting)

chulett · Post by **chulett** » Fri Feb 15, 2008 7:28 am

Paste your exact error here (not something 'like' it) and tell us exactly how you 'tried with LongVarchar'. Details, man, details!