Integration service Express/2005
I finally bit the bullet and uninstalled all of Sql Server 2005 and installed Sql Server 2005 Express both Advanced and the Toolkit. I can get in and see everything locally and my production Great Plains server just fine through Management console. The one thing I can't do is open an integration package to process our credit cards.
It's a pretty simple integration, but when I go to open it in SQL Server Business Intelligence Development Studio, the only thing it shows installed was Reporting services, not Integration services. When I try to open the project it gives me:
"The application for project 'c:\pcard...' is not installed. Make sure the application for the project type(.dtproj) is installed."
I had a problem earlier with the gui not coming up but was resolved when I applied SS2005 SVP 2. Some items wasn't on the same version. I re-applied svp 2 after I installed SS express and still got the above. If I try and 'add' Integration Services, either thru Express or just regular ss2005, it says it's already installed.
Do I have to modify the registry so that it comes up on Business Intelligence Dev Studio? I can't run the integration if I can't open the project.
