Running a Package on the server

[dave755]

I have a DTS package that was developed on a workstation using the developer's login. Now I want to schedule that package as a SQL Server Job to run on the server once per day.

Unfortunately, we are running into permission problems when the package tries to run.

What is the conventional setup for running a package on the server? What permissions do I need to set up? Do I need a special login?

thanks,
Dave

Dave Gee

 

[Krickles]

I'm not able to connect to my DTS packages to test, but try:

Editing the connection and changing the user
Drop and remake the connection with the appropriate user

Make sure the user name you choose has full permissions on the target db.

Krickles | 1.6180