How to view SSIS Package Owner? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to view SSIS Package Owner?

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
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.
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]
]]>