"String data, right truncation" error msg
Posted: Fri Apr 08, 2005 12:22 pm
Hi guyz,
I am doing a straight load from a sequential file to the database table (SQL server). There are 91387 rows in the sequential file. Its giving me 8 warning msgs. The msg goes like this
" XTR_SrcBatSap_SOSD3002..TRF_ConvertDataTypes3: [Microsoft][ODBC SQL Server Driver]String data, right truncation "
where source stage name is XTR_SrcBatSap_SOSD3002 and transformer stage name is TRF_ConvertDataTypes3.
The data gets loaded, the data looks fine too, but i need to get rid of these warning msgs.
How do i resolve this problem.
Help needed.
I am doing a straight load from a sequential file to the database table (SQL server). There are 91387 rows in the sequential file. Its giving me 8 warning msgs. The msg goes like this
" XTR_SrcBatSap_SOSD3002..TRF_ConvertDataTypes3: [Microsoft][ODBC SQL Server Driver]String data, right truncation "
where source stage name is XTR_SrcBatSap_SOSD3002 and transformer stage name is TRF_ConvertDataTypes3.
The data gets loaded, the data looks fine too, but i need to get rid of these warning msgs.
How do i resolve this problem.
Help needed.