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.
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Use this query to obtain the information you are looking for: SELECT [dts].[name] [package_name],
FROM [msdb].[dbo].[sysdtspackages90] [dts]
ORDER BY [package_name]