January 31, 2009 at 9:14 pm
My development environment is Visual Studio 2008 (Standard) and SQL Server 2008 express on a laptop running under Windows XP Home SP2.
I recently installed SQL Server 2008 (Standard) on a Vista desktop on our network so I could use Business Intelligence Development Studio to help with database migration, but logging in remotely to the desktop is a headache.
Since upgrading to SQL Server 2008 Express, the Visual Studio 2008 on my development laptop has templates for SSIS and Business Intelligence Development Studio, but when I try to use them I get the error message:
Microsoft Visual Studio is unable to load this document.
To design Integration Services packages in Business Intelligence Development Studio, Integration services needs to be installed by one of these editions of SQL Server 2008 Standard, Enterprise, Developer or Evaluation. To install Integration services, run SQL server setup and select integration services.
It was my understanding that SQL Server 2008 Business Intelligence Development Studio could not work under Windows XP Home, but I see most of the templates have been installed. With the installation DVD for SQL Server Standard, is there any way I can get BIDS functionality in the Visual Studio on my laptop? -Thanks for any help!
March 5, 2009 at 2:09 pm
This Error can happen when you just have BIDS installed, and is a bug that we have been working to fix. The licensing check expects to see SSIS installed, and you only have BIDS installed. Sorry about that 🙂
"Microsoft Visual Studio is unable to load this document.
To design Integration Services packages in Business Intelligence Development Studio, Integration services needs to be installed by one of these editions of SQL Server 2008 Standard, Enterprise, Developer or Evaluation. To install Integration services, run SQL server setup and select integration services."
Microsoft is hoping to ship the fix in Cumulative Update #4 for SQL 2008 coming out real soon. I am working on a KB 963070 content to describe the remedy which should release whenever the hotfix ships.
Meanwhile, on the client desktop, you can install Intergration Services. Run Setup and add the "Integration Services" feature to the existing installation of BIDS. To do this, rerun the Setup program, and then select Add Features to an Existing Installation. For more information, visit the following MSDN Web site: http://msdn.microsoft.com/en-us/library/cc281940.aspx
Regards, Jason H
April 21, 2010 at 2:03 pm
I have SQL 2008 installed on a development SQL server and have the SQL Client tools installed on my desktop client (SQL Server Management Studio & BIDS). When I launch BIDs and create a project (or open any .dtsx) I get the same error:
Microsoft Visual Studio is unable to load this document.
To design Integration Services packages in Business Intelligence Development Studio, Integration services needs to be installed by one of these editions of SQL Server 2008 Standard, Enterprise, Developer or Evaluation. To install Integration services, run SQL server setup and select integration services.
Integration Services is installed on my SQL Server (I've already created projects there), however I don't see how that matters at this point, since I'm just using the client tools. Do I have to have the full install of SQL 2008 on a client, just to use BIDS against the real server?
August 19, 2010 at 5:11 pm
I have the same problem. I know I have Integration Services installed because I have uninstalled them twice and reinstalled twice (second time trying SQL Server 2008 R2). It also appears in Services under SQL Server Integration Services 10.0 , and it is currently running. I also installed Service Pack 2 a few weeks ago. When I go to Add/Change installation features Both BIDS and Integration Services are checked and grayed out.
Any ideas how to get this fixed other than reinstalling Windows.
I am running Windows 7 64bit and have the following Microsoft Products installed:
SQL Server 2000 Enterprise Manager
SQL Server 2005 Management Studio & Integration Services & BIDS
SQL Server 2008 R2 Management Studio & Integration Services & BIDS
Visual Studio 2005
Visual Studio 2008
Visual Studio 2010
Office 2010
Thanks!
August 19, 2010 at 6:37 pm
I actually resolved this recently. I believe I'm on SQL 2008 R1 though... and the install is a custom build through my parent company. After the install of the client tools w/BIDS included, I just had to install the latest patch and it worked. You actually don't need IS installed to make it work. At least as far as my scenario with IS was on the server and I was installing client tools on my desktop.
Now one thing though... because of the fact that I tried lots of things before that, my install was hosed! I did have to get my pc rebuilt... which turned out to be a brand new pc. Best one in the site! Heheh. 🙂
August 24, 2010 at 9:56 am
Thanks! This resolved the issue. Last time I only uninstalled BIDS & Integration Services and just reinstalled those. However the Hotfix wouldn't install since the Service Pack 1 was already applied to SSMS and when trying to open a SSIS package still displayed the Error message. This time around I completely uninstalled all components of SQL Server 2008, BIDS, IS, SSMS . Which also removed the Service Pack, I then reinstalled SQL Server 2008 R1 without Integration Services, installed the hotfix, then updated to Service Pack 1 and everything is working now. The key was completely uninstalling everything.
Thanks again.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply