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

What error message are you getting? When you say you are manually Logged in as admin, does that mean you are manually logged in on the server or on your workstation?

It could be related to this:
In the services applet look at SQL Server Agent, at the Login in as. You want this to be a domain user -- who has a mail profile set up.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com