Calling SSIS package using C# Code !

Question

I am getting this Error when I call this SSIS Package using C# code. However, the package runs fine in it's own environment. The error that is displayed is --

The task <Script Task Name> cannot run on installed　 (64-bit) of Integration Services. It requires Standard Edition (64-bit) or higher.

Can anybody help me make this code work?

Answer 1

I think the key is Standard Edition. What SQL Server edition is installed on the failing system?

Answer 2

Microsoft SQL Server 2008 (SP1) -

<dir>

Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

Is that casue for concern?

</dir>

Answer 3

Hi Abhinav !

Please have a look at below MSDN artilce;

http://msdn.microsoft.com/en-us/library/ms136090.aspx

Usually we have BIDS client tool available with MS SQL Server 2008 Enterprise Edition, but you need BIDS Standart Edition or Enterprise Edition to be run this.

Thanks, Hasham Niaz

Answer 4

Hi,

Do you have SSIS installed on your server?

This looks like a similar issue

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/625d0475-30e5-4b45-95cc-6f49742569a0 

Regards
Satheesh

Answer 5

Hi Abhinav !

Please have a look at below MSDN artilce;

http://msdn.microsoft.com/en-us/library/ms136090.aspx

Usually we have BIDS client tool available with MS SQL Server 2008 Enterprise Edition, but you need BIDS Standart Edition or Enterprise Edition to be run this.

Thanks, Hasham Niaz

 I have installed SQL Server 2008 R2 and SQL Server 2008 as well. But BIDS is available only with the R2 version of SQL. Now is this a considerable problem ?

Answer 6

Hi Abhinav,

Did you look at the link?

You can use the following command to verify if SSIS in installed

SC Query MsDtsServer100

If the service is installed you should get:

SERVICE_NAME: MsDtsServer100
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 1  STOPPED
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x0

 

otherwise you should get an error:

[SC] EnumQueryServicesStatus:OpenService FAILED 1060:

The specified service does not exist as an installed service.

Have a look at this link too

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/867581f3-0dec-4c87-a197-3e60d5518b58

Regards
satheesh

Answer 7

Can you just look "SQL Server Integration Services 10.0" in Services.msc? If its not there, probably, you may have to install it.