DSXchange

Hi,

My Database is SQL Server.

I am able to import table definition from the database.

when i try to view data from the ODBC stage, i am getting the error
CHECK DATASTAGE IS SETUP CORRECTLY.

when I delete this column MESSAGE LONGVARCHAR of length
2147483647 from column definition, i am able to view the data.

what datatype that i should use for this colummn MESSAGE or is any other way to solve.

please help me in solving this issue.

Thanks & Regards
Sundar

What is the datatype of this 'message' field in your database? Some types, like TEXT fields, are not easily supported - if they are supported at all.

For TEXT datatype, we are using Varchar(2000) and the jobs are running fine.

Hi

Thanks to Everyone.

Datatype for the Column MESSAGE in database is TEXT.

In Datastage i typed varchar 2000 for this column,but it is throwing the same error.

ERROR CALLING SUBROUTINE:DSD.Browse (Action = 3): check

Datastage is setup correctly in project

Thanks
Sundar

Hmmm... actually, I was thinking of some conversations I'd recently had on the subject of TEXT fields in Sybase, not SQL Server. Since I know Jack about the latter, I'll bow out and let others help.