• Jpotucek (1/6/2015)


    I am attempting to grant access to a user (in DEV) to some legacy DTS packages that I have set up in a SQL Server 2012 Instance.

    He can see the packages but is getting is getting the following error attempting to open the package:

    The EXECUTE permission was denied on the object sp_enum_dtspackages, database msdb, schema dbo. (Microsoft.SqlServer.DtsObjectExplorerUI)

    As Sysadmin, I am able to open the packages. What permissions to I need to grant to this user so that they can open these packages as well???

    Correction. This is SQL Server 2008 NOT 2012