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?
rmarshall82Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PedroCGDCommented:
are you running from a machine with SSIS Installed?
and witch version of SQL you have? Check here:
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

need entreprise version to have ssis...

Helped?
Regards,
Pedro
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
0
pssandhuCommented:
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.
0
PedroCGDCommented:
You must have SSIS installed on client machine... even if you have SSIS in server.
Regards,
Pedro
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.