SAP Knowledge Base Article - Preview

1927170 - Datetime field overflow error in Data Services job when target is MS SQL Server 2012

Symptom

  • Data Services populates a Datetime filed in MS SQL Server 2012 target table.
  • Target data store is created as ODBC and driver used to created ODBC data source is SQL Server Native Client 10.0
  • When running the job throws the following error: Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding.


Read more...

Environment

  • SAP Data Services
  • Microsoft SQL Server 2012

Product

SAP Data Services all versions

Keywords

2012 ms sql datetime ds , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.