SSIS Deployment : The task <task name> cannot run on this edition of integration services. It requires a higher level edition

My SQL Server Database Engine is installed on a remote machine and the Development Tools(BIDS and SQL Server Management Studio) is installed on my local machine.

Using BIDS, I have created a SSIS package. It runs without any issue when executed from BIDS (By pressing F5). But, when I deployed this package onto the SQL Server and tried to execute it from SQL Server Management Studio, it gave me the following error :

The task <task name> cannot run on this edition of integration services. It requires a higher level edition.

After a little research, I found that the version of Integration Services installed with Database Engine on remote machine is different from what is installed with Dev. Tools on the local machine.

Also, the SQL Server is an Enterprise Edition whereas, the BIDS on local machine is Professional Edition.

1) Are the above 2 facts possible reasons for this error? 2) What are the ways (other than Tool upgrade) to get rid of this error?

Thanks

Answers


where qre you running the package from? Bear in mind that the package is run on the box that called it, not the one xhere it is stored.

Also you said: that the version of Integration Services installed with Database Engine on remote machine is different from what is installed with Dev I think thats the issue, you cant run a package built on 2008 on a 2005 server


On the remote server create a foolish import export pkg with the wizard in ssms and save the pkg some where... do the same on the dev machine and the open the pkgs with notepad and look to the difference in the headers (usually the problem is there).

Ex of a 2008 pkg

<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="SSIS.Package.2">
<DTS:Property DTS:Name="PackageFormatVersion">3</DTS:Property>
<DTS:Property DTS:Name="VersionComments"></DTS:Property>

Thanks everyone!!!

Here is what worked for me :

When we run the package by right clicking it in the Object Explorer(in SSMS), the package runs on the machine where we start it. It does not run the package on the server machine. We either need to install SSIS on the machine where we are trying to run the package from, or run the package on the server machine directly.

Reference

I executed the package on a different dev machine (with SSIS installed), and it worked!!!


Need Your Help

Set different constraints for iPad in portrait and landscape mode

ios ipad storyboard autolayout size-classes

When the device is in portrait orientation I have tableView and graphView in a viewController. When i change to landscape mode, i want to display only graphView. I am using size classes to do it. It

iPhone events handling

iphone events touch drag

does anybody know how can I handle the events(touch, drag) in UIApplicationDelegate instead of UIView?