INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Scheduling DTS Packages

How can I ensure that my scheduled DTS Packages will execute correctly? by TomSark
Posted: 14 Nov 00

When your DTS packages get scheduled, a thing to keep in mind is that the SQL Server Agent executes them and they may not work as you intended due to the fact that the Agent is most likely running under a different security context.

Here is a checklist you can use to ensure a smooth transition for packages where the security context changes from the creators context to the Agents context:

* The package is owned by you
* The agent account is a domain account being authenticated by a DC in, say, DOMAIN2
* The SQLAgent is being run under the context of a domain account
* The SQLAgent account and your account are both members of BUILTIN\administrators on the SQL Server
* The SQLAgent account and your domain account are members of the sysadmin fixed server role
* The directory in which the files reside is shared, with
"Change" and "Read" permissions granted to BUILTIN\administrators
* The SQLAgent account and your domain account have been permitted access to the SQL Server database
* These users have not been explicitly DENIED access to any object being "touched" by the DTS package in the database.

I hope this helps...

Tom

Back to Microsoft SQL Server: Programming FAQ Index
Back to Microsoft SQL Server: Programming Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close