Date and Time issue in SQL Server 2005 & 2008 RRS feed

  • Question

  • We have used Adventure Works DW 2005 database and now we want to update Adventure Works DW 2008 database to the BIDS current project. But there is some problem in the cube TIME and DATE dimensions. Please suggest. The problem we are facing: Error 64 OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimTime'.; 42S02. 0 0 Thanks
    • Moved by Aaron Alton Thursday, April 30, 2009 4:28 AM AWDW Question (From:Getting started with SQL Server)
    Wednesday, April 29, 2009 3:19 AM


  • Howdy, Sanjana. I'm not sure I follow what you're trying to do. The 2005 cube design is NOT compatible with the 2008 data warehouse; you need to use the 2008 cube design.
    David Reed - MSFT - Microsoft Certified Architect|SQL Server - http://blogs.msdn.com/reedme/
    Monday, May 4, 2009 5:48 PM