Can’t create SSIS solution in BIDS R2 after installing SQL Denali CTP1

Although, this is not PowerShell, I do work with SQL Server and SSIS packages.  I shouldn’t be surprise to find problems because I installed a CTP (Community Technology Preview).  I do expect to have some issue so I can figure out the answers, find the workaround to fix it, and then blog about it.

Well, here’s one issue I found after installing the new SQL Server ‘Denali’ CTP1 on my Windows 7 along with my RTM version of SQL Server 2008 R2.   I needed to develop a new SSIS solution using SQL Server 2008 R2 BIDS and I ended up with the following error:

image

image

image

So, my first thought was, Oh-Oh!! Machine rebuild! 

But, after having good experience with the recent release of SQL Server uninstall process, then I decided to do the following steps:  ( and it did work for me )

1. Under your Windows 7, Control Panel | Programs | Uninstall Programs, go to and right-click on “SQL Server Denali CTP1 Setup” or “SQL Server Denali CTP1 Setup (64bit)” and select “uninstall”.  You may need to media in order to proceed with the uninstall.

image

image

image

2. Go through the SQL Denali uninstall setup steps, until you reach to the “Select Instance” where you pick to “<<Remove shared features only>>”.

image

3. Now, you only going to “Select Feature” you really want to uninstall, which is “Business Intelligence Development Studio”.  Click Next to continue.

image

4. At the “Removal Rules” click Next, and at the “Ready to Remove”, Click Remove to start the uninstall process.

5. You will get the following screen, click Close to finish, and you will need to restart your machine.

image

image

Are we done yet?  No!! 

I want to make sure I uninstall all BIDS versions starting with SQL Server Denali and then SQL Server 2008 R2.  So, we need to repeat all previous steps but for SQL Server 2008 R2:

image

After, you’ve done repeating the steps and everything completed successfully, now we can install SQL Server 2008 R2 in order to recover this BIDS version.

image

image

Now, we are ready to re-install SQL Server 2008 R2 BIDS.  This step may ask you for the SQL Server media.

image

image

image

image

Keep clicking Next until the process starts installing the BIDS.

image

Now, the final test. Let’s open BIDS R2 and create an SSIS solution.

image

And, we got our BIDS R2 working again.

image

I hope this information helps everyone out there.

Smile

%d bloggers like this: