Tuesday, February 7, 2012

Gallery script: List all SSIS packages in MSDB (SQL 2008-2012)

Just uploaded a small contribution to the Technet Gallery. It was created originally by Olaf Helper, however it was working on SQL Server 2005 only.

So this script will list the SSIS packages stored in the MSDB from SQL Server 2008 to 2012, with some additional details:
  • Package type
  • Owner name
  • Encryption
  • Date of creation
  • Version
  • Version comment
  • Package size in bytes
This script fails on SQL 2005.
I checked the documentation of SQL 2012, and it is subject to change, but it seems that the system table names for the MSDB package won't be modified.

1 comment:

  1. Szia Zoli, nem bírtam megállni, itt egy powershell megoldás ugyanerre :)

    http://coloredcubes.blogspot.com/2012/02/ssis-csomagok-listaja-1.html

    ReplyDelete