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.
"String data, right truncation" error msg
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need to establish which column is causing the offence. Then check your source data (perhaps within DataStage - an extra output containing both the column and its length) looking for things like trailing space characters that cause the column to be longer than the maximum length specified by its SQL data type. DataStage doesn't care, and will process such data quite merrily, but - as you observed - SQL Server does care.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.