Post reply

SMTP Connection not found when executing the Job for the Package

  • November 4, 2009 at 3:41 am

    #216438

    Hi,

    I have a package which after executing sends the destination file to the user through Mail as an attachment.

    The package is executing properly without any error in SQL server development environment. The error is happening only when executing the Job in SQL Server Management Studio.

    I am getting the following error.

    Code: 0xC001000E Source: Package Name Description: The connection "SMTPConn" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error Error: 2009-10-29 11:01:31.16

    Where SMTPConn is the name of the SMTP Configuration Manager containing details of the SMTP server from where the mail has to be send.

    Even though the error comes after executing the Job, the destination file is send across through Mail to the user as it should be. So package is serving the purpose what it should do but I need to remove the above error also.

    Any suggestion regarding the above strange issue.

    Thanks

  • November 7, 2009 at 4:38 pm

    #1076384

    If you are able to have your package working in one case, the only reason for the other case not work is if you use configurations in one case and not the other. Find out where does SMTPConn reference is coming from.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply