Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    23

    Unanswered: problem sending email

    I'm trying to send email through Integration Services (based on when a package has been executed successfully) however I get this error message:

    SSIS package "CopyEmailTable.dtsx" starting.
    Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Failure sending mail.".
    Task failed: Send Mail Task
    SSIS package "CopyEmailTable.dtsx" finished: Success.

    Sending email via Mgmt Studio works fine, but not through Integ Services.

    Any help in this is greatly appreciated!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Possibly Integration Services is using a different logon than your own, and does not have priveleges to send mail.

    Consider using xp_smtp_sendmail instead: http://sqldev.net/xp/xpsmtp.htm
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jan 2007
    Posts
    23
    will this work with SQL Server 2005?

    Also, how can I change how I log into Integ. Services, if that is the issue?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •