Help: Job Failed (Error)

Dear All,
I have a DTS Package. When I run the package manually, it works, but
when it is executed by scheduled job, it always fail.
The error message is :
"Executed as user: <DOMAIN>\<Username>. The step did not generate any
output. Process Exit Code -1073741819. The step failed."
Pls help me to solve it out.
Thanks
Robert LieSee if this helps you understand what's happening:
http://support.microsoft.com/default.aspx?scid=kb;en-us;269074&sd=tech
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:easHEE4kFHA.2472@.TK2MSFTNGP15.phx.gbl...
Dear All,
I have a DTS Package. When I run the package manually, it works, but
when it is executed by scheduled job, it always fail.
The error message is :
"Executed as user: <DOMAIN>\<Username>. The step did not generate any
output. Process Exit Code -1073741819. The step failed."
Pls help me to solve it out.
Thanks
Robert Lie

HELP: Connecting to a secure file share using DTS

I have a dts package that works in connecting to a secure file share when I run it manually. When I schedule it to run on its own - it fails due to the lack of a log on. Is there something I can do to initiate the log in via the schedule rather than me manually doing it ?

Thank you!

When you run it manually, it's executing under your security context. When you schedule it, it will run under the security context of SQL Server Agent service account if the job is owned by a sysadmin. You need to grant the SQL Agent service account permissions to the share. The following article explains this issue:

INF: How to Run a DTS Package as a Scheduled Job

http://support.microsoft.com/kb/269074

-Sue