"String data, right truncation" error msg

DSguru2B · Post by **DSguru2B** » 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.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Apr 08, 2005 2:46 pm

Compare the column length of DataStage target and actual length in the db.

DSguru2B · Post by **DSguru2B** » Fri Apr 08, 2005 3:16 pm

Have checked that before. Thatts not the problem.

ray.wurlod · Post by **ray.wurlod** » Sat Apr 09, 2005 4:34 pm

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.