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.
Elliott Whitlow
SSC Guru
Points: 102402
More actions
July 24, 2013 at 9:19 am
#1635409
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