Nvarchar - Datatype Not Supported
Posted: 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,
How could we read the columns with NVarchar(max) in datastage.
Thanks in Advance....
I found there is a column 'Notes' in the table with data type of NVarchar(max) length, which is giving the problem.
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.
How could we read the columns with NVarchar(max) in datastage.
Thanks in Advance....