Job Failed: NZReports - Daily (6am) | Step 2 | Email_HNE_Daily_Report

[assasafras]

Message

Executed as user: FLEXIRENT\syssql02. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 6:00:18 a.m.
Error: 2016-10-12 06:00:18.60
Code: 0xC002F304
Source: Email_HNEDailyReports Send Mail Task
Description: An error occurred with the following error message: "The specified string is not in the form required for an e-mail address.". End Error DTExec: The package execution returned DTSER_FAILURE (1).
Started: 6:00:18 a.m.
Finished: 6:00:18 a.m.
Elapsed: 0.53 seconds. The package execution failed. The step failed.

[assasafras]

Issue

There was a stray "]" character after one of the emails provided.

Solution

Removed the stray "]" character within the email string.

[assasafras]

Email hasn't arrived to me yet, need to confirm it was sent...

[assasafras]

Issue

Email not sending as Sened Mail Tasks in SSIS only accept a maximum of 255 characters for the To Line.

Solution

Send Mail Task disabled in favour of an Execute SQL Task which calls sp_send_dbmail and maps package variables to the sp's parameters.

[assasafras]

DEV Environment

• Successfully ran under "Test Job" on DEVAKL006V SQL Job Manager.

[assasafras]

SIT Environment

• Successfully ran under "Test Job" on SITAKL006V SQL Job Manager.

[assasafras]

UAT Environment

• Ran under "Test Job" on INTGAKL006V SQL Job Manager.
• Email sent successfully.

[assasafras]

Production Environment

• Job Step enabled (NZReports - Daily (6am) | Step 2 | Email_HNE_Daily_Report).

[assasafras]

There was a hidden character at the end of one of the email addresses...