SAP Knowledge Base Article - Preview

1662683 - Error: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value - Data Services

Symptom

  • Dataflow writing to SQL Server target
  • Table DDL is using datetime data type
  • Database version in datastore is Microsoft SQL Server 2008
  • Error: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value


Read more...

Environment

  • Data Services
  • SQL Server 2008

Product

SAP Data Services 4.0 ; SAP Data Services XI 3.2

Keywords

DS, DSXI, datetime, datetime2 , KBA , EIM-DS , Data Services , 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.