Problem

When running an SSIS package from a SQL Server job the following error appears:

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

 

Solution

Usually this error appears when the SSIS service is not installed on the machine running the package. Although you have Workstation Components / Client Tools installed and you can create, debug and run packages using BIDS (Business Intelligence Development Studio), to execute the same packages from SQL Agent you need to have the SSIS service installed.

 

...

 

To check if the SSIS service is installed, open ?SQL Server Configuration Management? and go to ?SQL Server Services?:

 

 

To install the service, you must run the SQL Server setup and mark the ?Integration Services? checkbox:

 

 

 

I also encountered the same problem in another scenario.

On the same machine I had installed both SQL Server 2005 and 2008 database services. Both installations were Enterprise edition and the SSIS service was 2005. I received the above error with the following configuration:

-          The SQL Agent job that was supposed to execute the SSIS package was created on a SQL 2008 instance.

-          The SSIS package resided in the msdb database from a SQL 2005 instance

-          SSIS service was 2005

The solution in this situation was to simply move the SQL Agent Job from the SQL Server 2008 instance to the SQL Server 2005 instance (which also hosted the SSIS package in msdb database).

 

 


No feedback yet

Leave a comment


Your email address will not be revealed on this site.
(Line breaks become <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)