Kind regards, Gail Gail Erickson This posting is provided 'AS IS' with no warranties, and confers no rights. These items must be corrected before you can continue the sample database installation. If you have an instance of SQL Server 2008, I would suggest installing the first setup which will install all AdventureWorks sample databases. By default, the SQL Server sample databases are designed to use Microsoft SQL Server 2008. This will display whatever prerequisite is missing from your installation of SQL Server. Which of the AdveWks DB do I download: AdventureWorks2008SR4.exe OR Both of two setups are for SQL Server 2008. If there is a yellow caution icon, click the More Information button. When you get to the installation page titled 'Database Selection', make sure that there is a checkbox next to AdventureWorks OLTP 2008. From, c lick the green download button for SQL Server 2008 SR4. Unfortunately, the instructions printed in the MCTS Self-Paced Training Kit (Exam 70-432) were based on a pre-release method for downloading the sample databases. If not already entered, specify the machine name that you installed your SQL Server instance to in the previous exercise.Click Start, and then select All Programs, Microsoft SQL Server 2008, and SQL Server Management Studio.Run the installation routines for both downloads and use the default extract location.Scroll to the bottom of the page and download the AdventureWorks2008*.msi file to your local machine.Open Internet Explorer and go to Click the Releases tab.

I followed these instructions per the MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008: Implementation and Maintenance: I am unable to install the AdventureWorks2008 and AdventureWorksDW2008 databases from the CodePlex Web site. Modify the Configuration to suit your local. Download the Adventure Works 2008 database from here. This project contains Database samples released with Microsoft SQL Server product. An archive of the CodePlex open source hosting site.

Can you provide the details of this new functionality and an example of how to use it? The enhanced Lookup transform works hand-in-hand with the Cache transform.

One of the new SQL Server 2008 features in SSIS is an enhanced Lookup transform that includes the ability to cache the lookup data locally. MUST I uninstall the 2005 AdvenWKs before installing 2008? What happens to my sample projects that are based on the 2005 if I must uninstall it before installing 2008? What are the major differences between the 20 versions? Thanks in advance. AdventureWorksLT2008_Only_Database.zip 2.

Adventureworks2008 sr4 exe