Hello,
I extract ntext field of Sql Server to nclob of Oracle.Job like bellow.
odbc connector ------> transformer ------>odbc connector
Transformer stage use longnvarchar,length unset.Data counts is about 60000.When extract all datas I get the information(not warning or fatal) from destination stage:
ODBC_Connector_27,0: [IIS-CONN-ODBC-000013] ODBC Info: SQLSTATE = 01004: Native Error Code = 0: Msg = [Microsoft][ODBC SQL Server Driver]data string , right truncation
But when I extract only one and the largest length data,no that information.Can anyone help me?
best wishes
using odbc connector, find data string , right truncation
Moderators: chulett, rschirm, roy
If you look into the Connectivity Guide for Microsoft SQL Server and OLE DB Data you will see that all string types get mapped to DBTYPE_WSTR which should handle big strings.
Simplify your problem by removing Oracle ODBC and replacing that stage with a PEEK stage. If the error remains, see if specifying a length of VarChar(100000) makes a difference.
Simplify your problem by removing Oracle ODBC and replacing that stage with a PEEK stage. If the error remains, see if specifying a length of VarChar(100000) makes a difference.
</a>I have replace ODBC CONNECTOR with PEEK stage,and there's no error as before(actually It's not a fatal or warning).I've check that max length of the records is 302839,so I couldn't use varchar.
It's strange that extracting only one record is right,but extracting all records will lead before 'error'.
Could you give me more suggestions?
It's strange that extracting only one record is right,but extracting all records will lead before 'error'.
Could you give me more suggestions?