SAP Knowledge Base Article - Preview

1498861 - Error converting data type datetime2 to smalldatetime in Microsoft SQL Server 2008

Symptom

Using the new Microsoft SQL Server 2008 data type 'DATE'  when running a job can generate the following message:

Error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 10.0] [SQL Server]Error converting data type datetime2 to smalldatetime.>.


Read more...

Environment

  • Data Services XI 3.2 SP2
  • Microsoft SQL Server 2008
  • Windows 2003
  • Windows 2008

Product

SAP Data Services XI 3.2

Keywords

DS , 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.