Post reply

Rights needed to administer DTS Packages

  • February 28, 2008 at 7:05 am

    #187159

    I know that dts packages are kept in the msdb database. The msdb db has some db roles dealing with dts packages (db_dtsadmin, etc). I have given these dts roles to a developer but he still can't generate dts packages.

    Any help would be appreciated!

    Thanks,

    Bob

  • February 28, 2008 at 4:52 pm

    #783524

    Hi Bob,

    Are you dealing with legacy DTS packages or SSIS packages? The "dts_" database roles in msdb work only for SSIS packages stored in msdb, not for DTS packages. You'll have to grant EXECUTE permission to the specific stored procedures that work for DTS package e.g. sp_add_dtspackage, sp_drop_dtspackage, etc.

    Greg

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

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