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 for Me (Login required).

Search for additional results

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