Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ninel
Posting Yak Master
141 Posts |
 Posted - 2006-04-10 : 10:13:08
|
| 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 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-04-10 : 11:25:58
|
| When you schedule the package it will run a dts command and probably run under the sql server service account.See what that is.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Send Mail Task Issue