SAP Knowledge Base Article - Preview

1891190 - Sysdate output to a SQL2005 table fails - SAP Data Services 4.1

Symptom

Output data from the sysdate() function to a MS SQL 2005 column defined as date time, the job will fail with the error:

<[Microsoft][SQL Server Native Client 10]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding.>


Read more...

Environment

  • SAP Data Services 4.1
  • SQL Server 2005
  • Windows supported platforms

Product

SAP Data Services 4.1

Keywords

KBA , EIM-DS-EXE , Job Execution , Bug Filed

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.