Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS - E-mailing from causes error Expand / Collapse
Author
Message
Posted Monday, December 3, 2012 8:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 24, 2013 8:34 AM
Points: 5, Visits: 27
All,

A week ago some outside consultants upended my world. They switch the e-mail server from "tom" to "katherine". We have tested e-mailing from SQL server and it works fine. We changes the server name from "tom" to "katherine" within the dtsConfig file. However we get the following error:

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: 8:54:15 AM
Error: 2012-12-03 08:54:50.21
Code: 0xC002F304
Source: Send Summary Mail Send Mail Task
Description: An error occurred with the following error message: "Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender".
End Error
Warning: 2012-12-03 08:54:50.22
Code: 0x80019002
Source: Package Cleanup
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specifie

Any suggestions?

Thanks in advance

Charles

SQL 2008
Post #1391992
Posted Wednesday, December 5, 2012 3:49 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 13,328, Visits: 10,195
It seems to be some sort of permission issue.
Which account is used to run the SSIS package?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1392899
Posted Thursday, January 3, 2013 2:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 4:24 AM
Points: 3, Visits: 88
I had a similar problem with a new mail server being implemented... the thing was additional updates were done at the same time.

It sounds similar so the link below may help

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/6e266a75-7738-4683-8e0e-1968707e74be

Steve
Post #1402234
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse