Page 1 of 1

How can i handle large size in Datastage serveredition 7.1

Posted: Fri Feb 15, 2008 3:06 am
by mohandl
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"

Posted: Fri Feb 15, 2008 4:31 am
by ray.wurlod
Experiment with VarChar and LongVarChar data types rather than Text.

Posted: Fri Feb 15, 2008 5:49 am
by mohandl
I tried with Longvarchar ,But no use (same error i am getting)

Posted: Fri Feb 15, 2008 7:28 am
by chulett
Paste your exact error here (not something 'like' it) and tell us exactly how you 'tried with LongVarchar'. Details, man, details! :wink: