SSIS - E-mailing from causes error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSIS - E-mailing from causes error

SSIS - E-mailing from causes error

Rate Topic

Display Mode

Topic Options

Author

Message

cgivens

Posted Monday, December 03, 2012 8:44 AM

Forum 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

Koen Verbeeck

Posted Wednesday, December 05, 2012 3:49 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 9,372, Visits: 6,470

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

Steve.W

Posted Thursday, January 03, 2013 2:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 4:09 AM
Points: 2, Visits: 52

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 »

Permissions