Send Mail Task Issue

Last Post 10 Apr 2006 06:24 AM by PaulMcKibben. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ninelg
New Member
New Member

--
10 Apr 2006 06:16 AM
I created a dts package that creates an excel report and then uses the send mail task to email it out. I created the package under the admin login becuase the emailing failed under my own login.

So here's the issue....The send mail task is successful when logging in as admin and manually executing the DTS package, but when I schedule the package as a job it fails. Am I doing something wrong?

Any help would be greatly appreciated,
Ninel
PaulMcKibben
New Member
New Member

--
10 Apr 2006 06:24 AM
You might want to download and use DTS SMTP mail "tool" from SQLDEV.net. The web site for the tool is http://sqldev.net/dts/SMTPTask.htm.



Acceptable Use Policy
---