Error when run a job, which execute a DTS package

#1

I have a DTS package, which creates an object (which is a DLL), registered
on the server.
When I execute this package, from the server, it works fine, the object is
created successful.

But I need this package to be scheduled, so I created a job, which runs
DTSRUN command in its step:
dtsrun /Smyserver /Uusername /Ppassword /Npackagename

But the job fails on execution. It is because of creating the object. From
one reason, the object cannot be created.
What is wrong?

Please help.
Thanks a lot.

#2

Possible to be the security settings.
So what have I do? What rights should I have to use for the object I'm
trying to create from DTS?

"DBA72" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Mihaela,
When you run a DTS package manually, it runs under the security context of
the account you are currently logged on with. When you schedule the DTS

package, it runs under the security context of the account that SQL Server
Agent runs under.

Quote:

Perhaps there are differences in the rights of these two accounts.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Error when run a job, which execute a DTS package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Error when run a job, which execute a DTS package - 04-06-2004 , 07:52 AM

Re: Error when run a job, which execute a DTS package - 04-06-2004 , 10:21 AM