Installing SQL Server 2005 BIDS (ugh)

September 24, 2013 Leave a comment

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.


Adding complex Data Types to T-SQL

August 10, 2011 Leave a comment

Jamie Thompson is on a campaign trail to get complex data types, and the ability to derive data types from existing table objects, added to T-SQL.  This would be a great feature, I can’t remember how many times I’ve had a data type change in a source table and then have to go through a handful of stored procedures and update the parameter types, or worse yet, variables and temp table types. 

Only to miss one and watch the ETL fail.

Respond to the Connect issue and be heard!