Count number of SSIS packages on a SQL Server

[Joost]

Is there a query/view/system table to count the nummer of SSIS
packages on a SQL Server.

Joost

[Alessandro Alpi]

Post by Joost
Is there a query/view/system table to count the nummer of SSIS
packages on a SQL Server.

Hi,
try to use this query:
SELECT COUNT(*) FROM sysdtspackages
--
Alessandro Alpi
Microsoft MVP - Most Valuable Professional
SQL Server - Systems Administrator
http://mvp.support.microsoft.com
http://italy.mvps.org

[MCP] [MCITP - Database Developer 2008] [MCTS] [MCT]

blog: http://blogs.dotnethell.it/suxstellino
community: http://www.dotnethell.it
sito personale: http://www.alessandroalpi.net