DSXchange

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

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"

how are you processing your tables, do you have 3 jobs for 3 tables, or just one job for 3 tables, because i think you will be using routine only if your jobs runs successfully and in "After job subroutine", if your extractions is fine you add a record to end of processed file right ? i a...

I think we should have to use Left() function to truncate to 40 char.
Trim function is used to eliminate Spaces

Regards,
Mohan

I think we should have to use Left() function to truncate to 40 char.
Trim function is used to eliminate Spaces

Regards,
Mohan

please tell me any one what is diffrence between datastage 7.1 and 7.5

I have to give demo client ,please replay back immidiately

Regards,
Ramu

Thx Ray,for u r quick reponds,

Stage type is ODBC Stage,please tell me What is GCI and VOC where i have to find and where i have to change in Datastage to find the solution.

Regards,
Mohan

Multiple streams are not running in datastage server for example if i ran two user defined SQL statemets thru datastage with two streams,i am getting error mesages randomly like 1.Timed out error 2. Abnormal Error 3.Incorrect VOC entry for $DS.GETPID and EACCESS permission deniend If any body knows ...

can you please tell me how many ways we can sheduling the jobs in datastage

what diffrence between parameters and enviromental variables in datastage server jobs