BusinessObjects Board

datetime2 data types in SQL Server 2008

dataservices job design

system November 2, 2010, 7:39am 2

Bug. see

120×120 10.4 KB

Problem with Datetime2 in SQL server 2008 performance

Hi, We recently upgraded our enviornment to SQL Server2008 and noticed dataflows that have Data Transfer (DT) with date fields crashing with below error. ODBC data source error message for operation : <[Microsoft][SQL Server Native Client 10.0]Numeric value out of range>. This is causing by the a new data type introduced in SQL server for date field called Datetime2. BODI is creating the DT with this new data type and our target tables are defined with datetime. The new data type is long…

Werner Daehn (BOB member since 2004-12-17)

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled