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!!