Home Forums Data Warehousing Integration Services Send Mail Task works perfectly within BIDS but does not work in SQL Agent Job. RE: Send Mail Task works perfectly within BIDS but does not work in SQL Agent Job.

  • July 24, 2013 at 9:12 am

    #1635404

    If you set up a proxy with the appropriate mail server access and ran the SSIS package under the security context of the proxy that should work. You should be able to find a number of articles on setting up a Proxy for the SQL Agent to use when running SSIS packages.