Hello,

I downloaded the db files (AdventureWorks_111810112X.mdf , AdventureWorks_DW_111810112X.mdf)
from this link http://www.wrox.com/WileyCDA/Section/id-811019.html

When I tried to attach the db files with SQL Server 2012 SSMS but failed with error messages. (it shows db names as AdventureWorks2008R2, AdventureWorksDW2008R2).


****error message

TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server . (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL11.DENALIRCO\MSSQL\DATA\AdventureWorks 2008R2_Data.mdf" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft SQL Server, Error: 5133)

For help, click: http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

****


I also had a look at the SSIS solution of chapter 3 and some packages have connections to some database called AdventureWorksDWDenali.


Kindly please help with this issue.



Thank you.

a) You should have downloaded two files:

AdventureWorks_111810112X.zip
AdventureWorks_DW_111810112X.zip

The 2nd of which is the Denali one you refer to. Both are needed for the boo.

b) When you attach the database two files are listed in the 2nd window, location to the mdf and the ldf. Repoint the mdf to be where ever you located it and delete the ldf pointer, SQL will create a new one for you.

Sadly it's not the job of an SSIS book to teach you about attaching or restoring databases so this can be a trip up. I've kept it brief as it's unlikely you're every going to read this.. but maybe someone will.