Symptom
- Target is MS SQL Server. Target column type is Varchar and length is great than 4000. and big enough to hold the data the data services inserts into the field.
- When Data Services job inserts data of length 4000 or lesser, the job works fine.
- When Data Services job inserts data of length more than 4000 the job throws the error: error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 10.0]String data,right truncation>.
Read more...
Environment
SAP Data services 4.x
Product
SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services 4.2 ; SAP Information Steward 4.0
Keywords
4001 right truncate truncation sql 4000 nvarchar ms sql , KBA , EIM-DS-EXE , Job Execution , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.