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.

  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
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. 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]

Share This Page