Installing SQL Server 2005 BIDS (ugh)

Recently, we had some legacy SSIS packages that needed to be updated.  Unfortunately, we weren’t in a position within our agile project management to update these to SQL 2008 or, much better, SQL 2012 (we need a ‘business reason’ for justification).

Such is life at a multi-billion dollar company.

Here are the steps I took to getting the BIDS install from SQL Server 2005 to work on my Windows 7 64-Bit PC:

1) Uninstall anything related to SQL Server 2005 and Visual Studio 2005
2) Track down an install of SQL Server 2005 Developer Edition (I used my MSDN license)
3) Run Setup for SQL Server 2005 32-bit
4) Choose the Connectivity tools and Business Intelligence Developer Studio (BIDS)
5) Install Visual Studio 2005 Service Pack 1
5) Validate install.  You should see ‘Integration Services’ as a project type

TFS 2012 Integration

These SSIS packages also integrated with TFS.  Previously with VS 2005 TFS 2010 Integration, there was a forward-compatibility pack you could install.  Now, it has been switched to the MSSCCI provider.

1) Download the MSSCCI provider
2) Open a Visual Studio Project
3) Under Tools—> Options, change the Source Control Plug-in to the MSSCCI provider
4) Under Tools –> Connect to Team Foundation Server, enter your server credentials (I had trouble getting the right format; your mileage may vary)
5) I also had to rebind the solution, under File—> Source Control

If anyone has installed the 64-bit versions of the above, I would be interested in knowing if that was successful.