Thursday, September 12, 2013

Fix: “To run a ssis package outside of sql server data tools you must install send successful email of Integration Services or higher.”

This error was seen with SQL Server 2012 version component (SSIS, DB Engine, Agent):

Error: “To run a ssis package outside of sql server data tools you must install send successful email of Integration Services or higher.”

Scenario:

Host 1 - SQL Server 2012 DB Engine and Agent.
Host 2 - SSIS 2012

Package would execute successfully if executed from Host 2. If executed from Host 1 (where the Agent resides, with the ultimate intention of running as a job), it produces the error. Send Mail Task was the focus of the error.

To fix, SSIS 2012 components had to be installed on Host 1.

*This is not a desired solution, as the intention was to keep SSIS components on Host 2 only. If anyone has a solution that does not require SSIS to be installed on Host 1, please post and I'll update the info.

Please see this post for additional info.

2 comments:

  1. I don't have a solution for this but I have the same issue.

    ReplyDelete
  2. Sharing this in case it helps with the troubleshooting: On another site a user indicated they solved the problem by setting an environment variable (for the host I assume, wasn't stated) and restarting the agent.

    ReplyDelete