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.

Hi Pete,

SQL Express does not include SSIS and the version of BIDS that installs with the Express Toolkit does not support opening SSIS packages. You will need to install one of the paid Editions of SQL Server 2005 to get SSIS functonality.

Mike

|||

Hi Mike,

when you say Express Toolkit does not support opening SSIS packages, do you mean it does not support saving packages or the schedule package?

I want to know if there is any way I can save packages and do the scheduled jobs strictly without the licensed SQL Server.

thanks in advance.

Mike

|||

hi Mike,

as Mike already pointed out, the BIDS version provided for SQLExpress does not allow you to open SSIS package..

BTW, SQLExpress does not provide the SQL Server Agent as well, so you can not even "schedule" package execution, and no "runtime" for SSIS is available.. you could, eventually, use DTS, as a runtime for it is provided at http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

regards

|||

Thanks Andrea...

I am still wrestling with SQL servers and I was wondering if you could give me a definite answer...

I am using enterprise manager to connect to SQL 2005 Express for snapshot replication. I've created new publications, and then using EXPRESS I created a local subscription to the publication.

But I could see no changes in my database.. Do you know why this is happening?

I tried to start the distribution agent (multiple publications) but some reason it can't connect to subscribers.

is this because 2000 and express can't connect to each other? or am I doing something wrong?

thanks

|||

Hi ,

I understand that the BIDS version installed with SQL Express Toolkit does not allow to open the SSIS packages. Does that mean that we cannot even execute an SSIS package from SQL server Express.

Thanks.

Vigya

|||

Hi Vigay,

Right, you can not use any part of SSIS in SQL Express, it isn't there. You can't run packages or anything else.

Mike