Date and Time issue in SQL Server 2005 & 2008

Answered Date and Time issue in SQL Server 2005 & 2008

  • mercredi 29 avril 2009 03:19
     
     
    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
    • Déplacé Aaron AltonModerator jeudi 30 avril 2009 04:28 AWDW Question (From:Getting started with SQL Server)
    •  

Toutes les réponses

  • lundi 4 mai 2009 17:48
     
     Traitée
    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/