Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how to troublshoot smtp send mail SSIS task

18 views
Skip to first unread message

Carl Henthorn

unread,
Jun 4, 2008, 12:55:01 AM6/4/08
to
I have a simple SSIS package that runs a sql query that exports to a flat
file, then emails this flat file to an address. I built the package in Visual
Studio 2005, where the package runs without a problem. I save the package out
to a sql 2005 sp2 server, and the package fails on the send mail tasks:
Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for
64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 9:24:06 PM Error: 2008-06-03 21:24:19.35 Code: 0xC002F304
Source: Send Mail Task Send Mail Task Description: An error occurred with
the following error message: "The SMTP server requires a secure connection or
the client was not authenticated. The server response was: 5.7.1 Client was
not authenticated". End Error DTExec: The package execution returned
DTSER_FAILURE (1).

Can someone please give me an idea on how to troubleshoot this? I would seem
that there is something wrong with the sql service account not authenticating
to the smtp server, but I am not sure.
Thanks in advance!!

Antoon

unread,
Jun 6, 2008, 3:10:02 AM6/6/08
to
The user with which you are executing the package has no rights to mail.
0 new messages