Count number of SSIS packages on a SQL Server

Count number of SSIS packages on a SQL Server

Post by Joos » Thu, 12 Nov 2009 17:10:13


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

Joost
 
 
 

Count number of SSIS packages on a SQL Server

Post by Alessandro » Thu, 12 Nov 2009 20:21:36

> Is there a query/view/system table to count the nummer of SSIS
Hi,
try to use this query:
SELECT COUNT(*) FROM sysdtspackages

--
Alessandro Alpi
Microsoft MVP - Most Valuable Professional
SQL Server - Systems Administrator
http://www.yqcomputer.com/
http://www.yqcomputer.com/

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

blog: http://www.yqcomputer.com/
community: http://www.yqcomputer.com/
sito personale: http://www.yqcomputer.com/