List all SSIS packages stored in msdb database

This Transact-SQL statements lists all SSIS packages stored in the msdb system database with detailed information.It gives a brief overview which packages exists, who created them and which is the actual version of it.Works with SQL Server 2005 and higher versions in all editions

4 Star
4,768 times
Add to favorites
E-mail Twitter Digg Facebook
  • 2008 compatibility
    1 Posts | Last post May 16, 2013
    • I like it - this is useful information. 
      It might be handy to note that the tables referenced in SQL Server 2008 are different (sysdtspackages90 ---> sysssispackages and sysdtspackagefolders90 ---> sysssispackagefolders).