The Integration Services

Question

Hi,

I am developing a program that gets all object from a SQL Server 2000 database so as to copy all objects including tables, storedprocs etc to another database. However something gone wrong with this line of code:

using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;

Transfer t = new Transfer(db);

TransferData();

It throws that error while executing:

The Integration Services component is not installed or you do not have permission to use it.

SQL Server 2000 Enterprise and SQL Server 2005 Express Editions are installed on my machine. I searched a solution for this problem but I found nothing. How can I install SSIS on my machine or anybody have any solution for this problem.

Answer 1

cakirhal wrote:

Hi, The Integration Services component is not installed or you do not have permission to use it. SQL Server 2000 Enterprise and SQL Server 2005 Express Editions are installed on my machine.

 

Express does not include SSIS. That is the reason for the error.

 

You need SQL Server 2005 Standard, Developer or Enterprise installed.

 

Let us know what happens.

Answer 2

Thank you for quick reply. It seems that I have no chance to install any version of SQL Server 2005 except Express on my computer because of SQL Server 2005 prices.

Answer 3

SQL Server 2005 Developer Edition (same as Enterprise but cannot be used for production) is fairly low priced around $45 retail.

 

Perhaps a good fit for you.

 

Answer 4

Thank you for informing about prices. I can get Developer Edition, it is really cheap but I have found a solution for this problem. I saw the Transfer class wasn't necessary for me and this article was very helpful.
Best Wishes.

Answer 5

On my machine, I had SQL Server 2005 Standard install and Integration Services component is running, but it still get the below message.

The Integration Services component is not installed or you do not have permission to use it.

how to set permission to use it?

Answer 6

On my machine, I had SQL Server 2005 Standard install and Integration Services component is running, but it still get the below message.

The Integration Services component is not installed or you do not have permission to use it.

how to set permission to use it?

I am having the same error message?

Did anyone has managed to resolve this?

Thanks in advance.

Vivek

Answer 7

When you go Services (or SQL Server Configuration Manager), do you SQL Server Integration Services n.m running?

Can you connect in Object Explorer to Integration Services?

Are you the admin?

If you see it but not running, start it up.

If you don't see it, you have to install it from the instal dvd.

---

Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com