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.

Fix: SSIS Warning of Truncation From Database to Data Flow Column

The error appears as follows, even after verifying matching source --> destination length.

Validation warning. [PackageName] {GUID}: Truncation may occur due to retrieving data from database column "[SourceColumnName]" with a length of (x) to data flow column "DataFlowColumnName]" with a length of (y).

To fix, open the data flow task. Select columns, then deselect the columns, and re-select all needed columns.

This was seen with SSIS 2012.