I currently use Visual Studio 2008 SP1 and have been migrating older projects into VS2008 but existing SSIS and SSRS (2005) projects have not been compatible with VS2008. It has been a pain to maintain those BIDS projects as a separate solution.
I have been considering upgrading to SQL2008 but because our dev, test and production platforms are all SQL2005 Enterprise Edition I do not like the idea of deviating my local environment from the current standard. Despite wanting BIDS for VS2008.
I just installed Sql Express 2008 with all the bits and something occurred to me... Did Sql Express 2008 just install all the BIDS bits I need without requiring me to upgrade my local version of Sql Server?
Is this a viable methods of installing BIDS for VS2008 or am I missing something?
UPDATE
I just had a thought... Why don't I just install the tools from the full SQL Server 2008 since I have access to that.
There is still the question of what differences there are between the tools from Express 2008 and the full Sql Server 2008.