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.
I don't have a solution for this but I have the same issue.
ReplyDeleteSharing 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