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
(12)
4,565 times
Add to favorites
Databases
8/26/2011
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • 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).