2
Vote

AdventureWorksDW not found

description

I can´t find AdventureWorksDW. SSIS 2008 Tutorials need AdventureWorksDW to run; I tried with AdventureWorksDW2008 but [DimTime] table doesn´t exists.
 
Where can I find it?
thx.

comments

DarrenBailey2008 wrote Jul 22, 2010 at 2:50 PM

I have the same problem, first piece of code executed from SQL server step by step andI get the following error:

Configuration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks2008.bak'. Operating system error 2(failed to retrieve text for this error. Reason: 1815).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorksDW2008.bak'. Operating system error 2(failed to retrieve text for this error. Reason: 1815).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Please help. It's not great hitting an error on the first page.

DarrenBailey2008 wrote Jul 22, 2010 at 2:51 PM

the original code:
EXEC sp_configure 'filestream_access_level',2;
GO
RESTORE DATABASE AdventureWorks FROM DISK='C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks2008.bak' WITH RECOVERY;
GO
RESTORE DATABASE AdventureWorksDW FROM DISK='C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorksDW2008.bak' WITH RECOVERY;
GO