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.