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.