A list of SSIS packages - SQL Server 2005

Is there a table I can query to get a list of SSIS packages in SQL Server 2005?
Who is Participating?
brejkConnect With a Mentor Commented:
Assuming the packages are stored in SQL Server and not in the file system, yes there is such table:

1) on SQL Server 2005

SELECT * FROM msdb.dbo.sysdtspackages90

2) on SQL Server 2008

SELECT * FROM msdb.dbo.sysssispackages
niceguy971Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.