Link to home
Start Free TrialLog in
Avatar of rmarshall82
rmarshall82Flag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of PedroCGD
PedroCGD
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rmarshall82

ASKER

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.
P.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial