Can I read SSIS Packages in MSDB Database List on EtoBox?

SSIS Packages in MSDB Database List by Satyanarayana is a document available to read on EtoBox.

What is SSIS Packages in MSDB Database List about?

This SQL code lists all SSIS packages stored in the MSDB database for SQL Server 2005, 2008, and 2012. It selects the package name, description, folder name, package type, owner name, create date, and package size from the relevant tables - sysdtspackages90/sysssispackages and sysdtspackagefolders90/sysssispackagefolders - joining on the folderid and ownersid columns. The version is checked to select from the appropriate tables for that SQL Server version.

Author

Satyanarayana

Language

EN