SQL Server Performance

How to view SSIS Package Owner?

Discussion in 'SQL Server 2005 Integration Services' started by DBADave, Nov 17, 2006.

  1. DBADave New Member

    Is there a stored procedure that lists package information such as owner? I tried joining sysdtspackages90 and syslogins, but found that the packages ownersid does not exist in syslogins. I'm not sure how that's possible.

    Dave
    DBADave, Nov 17, 2006
    #2

  2. satya Moderator

    Check ownersid value in this case, refer to Integration Services Roles in BOL.


    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
    satya, Nov 21, 2006
    #2

  3. stephen.kusen@gmail.com New Member

    Dave,
    Use this query to obtain the information you are looking for:

    SELECT [dts].[name] [package_name],
    SUSER_SNAME([dts].[ownersid]) [package_owner]
    FROM [msdb].[dbo].[sysdtspackages90] [dts]
    ORDER BY [package_name]
    stephen.kusen@gmail.com, Mar 24, 2008
    #3

Share This Page