How to get BIDS for Visual Studio 2008 SP1?

visual-studio-2008 sql-server-2008 sql-server-express bids
BlackMael picture BlackMael · Oct 26, 2008 · Viewed 25.9k times · Source

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.

Answer

ConcernedOfTunbridgeWells picture ConcernedOfTunbridgeWells · Oct 26, 2008

BIDS for SQL Server 2005 is based on Visual Studio 2005. AFAIK it won't install directly into VS2008.

Related questions

How can I automate the "generate scripts" task in SQL Server Management Studio 2008?

I'd like to automate the script generation in SQL Server Management Studio 2008. Right now what I do is : Right click on my database, Tasks, "Generate Scripts..." manually select all the export options I need, and hit select all on the "…

Read More
beginner's tutorial for report viewer?

I am using VSTS 2008 + C# + .Net 3.5 + SQL Server 2008 + ASP.Net + IIS 7 to develop web application. Any quick and easy to learn tutorial for report viewer -- I want to generate report based on data from SQL Server 2008. Basic design and …

Read More
How to debug a script component in SSIS

It's simple but I can't make it work, and I read in so many places a lot of solutions but nothing worked for me. How can I accomplished this? Note I put a break point in my code and ran …

Read More