Post reply

SSIS Package in a Job wont use Send Mail Task

  • September 30, 2010 at 6:43 am

    #241034

    I have a SSIS Package with a Send Mail Task in it. There is a three failure constraints pointing to it, as you all know, if one of the tasks fail an email will be sent. This works perfectly within BIDS...I can make the package fail and get the desired email. However when I put this SSIS package in a SQL Agent Job, the Send Mail Tasks do not send the desired emails to my recipients. However my SQL Agent Job emails me when the package fails. What needs to be done to get my Send Mail Tasks to send the desired emails while executing as a SQL Agent Job?

    Any and All help will be greatly appreciated...Thanks

  • September 30, 2010 at 8:11 am

    #1229643

    If the package works as expected from BIDS but not as a scheduled job, the first thing I would suspect is permissions.

    When you execute an SSIS package from BIDS it executes under your credentials. When you schedule it as a job the execution context depends on whether the owner of the job is a sysadmin. If the owner is a sysadmin, then the package will run under the creds of the Agent service account. If the owner is not a sysadmin, the package will run under the creds of whatever proxy you set up.

    So, first determine what creds the package is executing under. You can view this in the job history. Then check with your Exchange guy and see if that account has permissions to send email. My Exchange guy told me I needed "relay permission" - I don't know what that means, but it worked for me, so maybe you could toss that term around.

    HTH.

  • October 1, 2010 at 10:21 am

    #1230350

    Thanks Henry for the reply...

    My problem end up being that I installed a Third Party "Task" on my local machine, used it in my package, ran successfully from my local machine etc.

    Then when I deployed the package to the server, I did not install the Third Party "Task" and that was the reason for the failure (I assumed it failed for another reason, so I did not check into it). Once I installed the task on the server, the package is now working.

    Thanks Again...

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

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