Post reply

Permissions needed for DTS Package "Administrator"?

  • July 11, 2006 at 8:27 pm

    #61448

    We have several production DTS packages. The company has decided that in the event the DBA is not available, and a package fails to run successfully, that we need a backup person (not a DBA, most likely a knowledgeable developer) who can access/edit/run select DTS packages.

    Does any know of any graduated access permissions for administering DTS packages? Or do we have to make that person "sa" equivalent?

    TIA,

     

    Bill

     

     

  • July 11, 2006 at 11:12 pm

    #648627

    You will find in the msdb database a role called TargetServersRole. By granting exec permissions to certain system stored procs, such as sp_start_job, you can make the user a member of the role and create a job for the DTS package for the user to execute in the situation where the DTS package failed.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply