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.

  • Are you running the package in BIDS on the same machine that you are trying to run it on as a job.

    I have seen local firewall differences as well as access control rules on the destination side that could yield this.

    CEWII