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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-27 : 08:14:39
|
| Ram writes "I am trying to run a DTS package thru a Batch file. The DTS package has a email task within it. When I run the package from enterprise manager, the email task gets triggered and the task is sucessful. But when I run it thru the Batch file, the email is not being sent.(Outlook is always open in the machine that I am running; every task other than the email task runs sucessfully). " |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-28 : 12:17:35
|
| How are you running it from a batch file? Using dtsrun.exe? What happens when you run it from EM is that it uses the credentials of the person logged in. If you run it from a job, it would use the credentials from the service. Which credentials are you passing to dtsrun.exe? I'm not sure if the e-mail task would use those credentials (wouldn't work if you used sql authentication since that account doesn't have a mailbox) or use the credentials of the person logged into the machine. So which authentication are you using for dtsrun.exe?Tara |
 |
|
|
|
|
|
Running DTS Package with Email task using a Batch file