• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 683
  • Last Modified:

Executing SSIS package with Execution utility, "send mail" task cannot run on this edition of integration services. It requires a higher level edition.

Environment: SQL Server 2005, Business Intelligence Studio 2005, Windows XP.

When running the package in Visual Studio, it executes with no problem.  When trying to execute from Integration services, or from Windows scheduled task, I receive the error above: "cannot run on this edition...."

Any ideas on how to get the package to run?
  • 2
2 Solutions
are you running from a machine with SSIS Installed?
and witch version of SQL you have? Check here:

need entreprise version to have ssis...

rmarshall82Author Commented:
Executing the package from a client machine, with only SQL client tools installed, but couldn't get it to run on the server either.  The server is enterprise, with SSIS installed.  There are several packages that run both on the server, and from client machines.
Try this, Create a SQL Server Agent job on the server that will execute the package that you have created.
Here are the steps (assuming you know how to schedule jobs on SQL Server):
1. Create and save your SSIS package on the server
2. Open up SQL Mgt Studio and under SQL Server Agent cerate a new job.
3. In the job create a step and choose the step type as "Transact-SQL Script"
4. Type this in the SQL Query box: EXEC xp_cmdshell 'dtexec /f "C:\Program Files\Microsoft SQL Server\90\DTS\Packages\ImportManulifeData\Package.dtsx" '
5. Save and close the job wizard.
6. Run to see if it works.
Also, please note the EXEC xp_cmdshell, the path is subjective to where you store your package.
Hope this helps.
You must have SSIS installed on client machine... even if you have SSIS in server.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now