Count number of SSIS packages on a SQL Server

#1

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

Joost

#2

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Count number of SSIS packages on a SQL Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Count number of SSIS packages on a SQL Server - 11-11-2009 , 02:10 AM

Re: Count number of SSIS packages on a SQL Server - 11-11-2009 , 05:21 AM