using odbc connector, find data string , right truncation
Posted: Tue Oct 12, 2010 3:05 am
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
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