scheduling dts jobs fails

Hello,
Could somebody tell me what i'm doing wrong. I have created a dts job from
the client console on my computer. Next i want to schedule the dts job, but
whenever it starts it is always failing.
Is it because i've created the dts job on my computer? I can see the owner
of the job is the name of my computer/username.
Greetings,
Zeke
I guess it has to do with security. When you schedule a job, it is executed
under different user account, not under yours. if you are a member of the
sysadmin role, then it is executed using SQL Server Agent's account.
Otherwise you can use so-called proxy account (check more in Books OnLine).
And the account used might not have permissions (maybe on file system as
well, not just SQL Server, depends on whatever the package is doing). Or it
does not see the drives you mapped using your account, etc.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Ezekil" <ezekiel@.lycos.nl> wrote in message
news:%23EwqWe1MEHA.2540@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Could somebody tell me what i'm doing wrong. I have created a dts job from
> the client console on my computer. Next i want to schedule the dts job,
but
> whenever it starts it is always failing.
> Is it because i've created the dts job on my computer? I can see the owner
> of the job is the name of my computer/username.
> Greetings,
> Zeke
>