Nvarchar - Datatype Not Supported

DSMaestro · Post by **DSMaestro** » Tue Nov 24, 2009 3:50 am

When i was trying to extract column from a table mounted in SQL-Server 2005 database, I was getting the following error,

Error executing View Data command:##E IIS-DSEE-TDOD-00001 10:41:44(007) <main_program> Datatype Not Supported

##E IIS-DSEE-TDOD-00001 10:41:44(007) <main_program> Datatype Not Supported
##E IIS-DSEE-TOPK-00007 10:41:44(012) <_PEEK_IDENT_> Input dataset does not have field: "SupportCallEventID".
##E IIS-DSEE-TOPK-00007 10:41:44(013) <_PEEK_IDENT_> Input dataset does not have field: "Notes".
##E IIS-DSEE-TFSR-00019 10:41:44(015) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 10:41:44(022) <main_program> Creation of a step finished with status = FAILED.

I found there is a column 'Notes' in the table with data type of NVarchar(max) length, which is giving the problem.

How could we read the columns with NVarchar(max) in datastage.

Thanks in Advance....

chulett · Post by **chulett** » Tue Nov 24, 2009 6:38 am

What stage are you using? What does the documentation for that stage list as unsupported data types and/or as 'issues' for the stage?

DSMaestro · Post by **DSMaestro** » Tue Nov 24, 2009 7:13 am

chulett wrote:What stage are you using? What does the documentation for that stage list as unsupported data types and/or as 'issues' for the stage? ...

I'm using 'SQLServer Enterprise' Stage for extracting the records.

Documentation for this stage doesn't give any information about the unsupported data types.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 24, 2009 4:08 pm

NVarChar is supported. NVarChar(max) - aka TEXT - probably isn't. Try using a large bounded NVarChar.

chulett · Post by **chulett** » Tue Nov 24, 2009 4:22 pm

DSMaestro wrote:
chulett wrote:What stage are you using? What does the documentation for that stage list as unsupported data types and/or as 'issues' for the stage? ...
I'm using 'SQLServer Enterprise' Stage for extracting the records.

Documentation for this stage doesn't give any information about the unsupported data types.

You're right. That's too bad, the documentation for the other DB stages certainly does and I find it hard to believe that there are no issues or unsupported data types with these stages.

Sreenivasulu · Post by **Sreenivasulu** » Wed Nov 25, 2009 2:55 am

Use ODBC Enterprise/ ODBC Connector stage to get around this issue

Regards
Sreeni

desmondcheah · Post by **desmondcheah** » Thu May 13, 2010 9:37 pm

I've also notice.. when using ODBC Connection.. "table" read will get you this problem if there are VarGraphic datatype in the table.

But if you do a custome/user query and select normal datatype column.. it works.

*Cheers