Currently SQL Business Intelligence Development Studio (BIDS) and all the project types (AS, IS and RS) live in Visual Studio 2005. So don't try to open a solution that contains IS project in VS 2008 yet. What about final SQL 2008 - now that Visual Studio 2008 is released - what are the plans for BIDS and support of BI projects VS 2008?
Note that I have to comment on unreleased software, so the plans may change, and this information is provided as-is (as everything else in this blog, but even more so :)). Still, we got a lot of questions, I'll try to summarize this discussion.
The SQL 2005 is not going to change, SSIS 2005 is hosted in VS 2005, and you can't open SSIS projects in VS 2008 until you install SSIS 2008.
For SQL 2008 the plans are different:
Now regarding setup: how do I remove VS 2005 without impacting BIDS installation? If you have both VS 2005 and BIDS, there should be at least two entries for Visual Studio SKUs in Add/Remove Programs:
That was about designing SSIS packages. If you want to write SSIS custom components (tasks, transforms, etc), you can use either VS 2005 or VS 2008 to develop either SSIS 2005 or SSIS 2008 components - there is a lot more flexibility here. If you use VS 2008 and want to target SSIS 2005, open project properties and make the project target .NET 2.0 runtime.