Visual Studio and SQL Server - correct installation sequence?

Question

I am rebuilding my development machine. This issue is not new to me, but I don't remember the solution. I started with SQL 2008 Developer, then VS 2008 Pro, then the SQL SP1, then VS SP1. The result is that I cannot open SSIS projects (see the error below). What is the correct order so that I can avoid the installation of SQL Server Express and still have all the features working?

---------------------------
Microsoft Visual Studio
---------------------------
Package Load Failure

Package 'DataWarehouse VSIntegration layer' has failed to load properly ( GUID =
{4A0C6509-BF90-43DA-ABEE-0ABA3A8527F1} ). Please contact package vendor for 
assistance. Application restart is recommended, due to possible environment 
corruption. Would you like to disable loading this package in the future? You 
may use 'devenv /resetskippkgs' to re-enable package loading.
---------------------------
Yes   No   
---------------------------

Answer 1

You should install SQL 2008 Developer first, this will rule out the need for VS installing SQL which comes with it. Or you could do like others suggested and choose custom VS installation.

My favorite way is this:

1. SQL 2008 Developer
2. Visual Studio Professional 2008
3. Run Windows Updates
4. Install Resharper :-)
5. Install RedGate SQL ToolBelt

But it seems that to get some features to work the proper order is:

1. Visual Studio Professional 2008 (with SQL Unchecked)
2. SQL 2008 Developer
3. Run Windows Updates
4. Install Resharper/Redgate Tools

Resharper and Redgate in my opinion are far the best tools for developing in C#/SQL.