SQL 2005: SSIS Package List

-- sql 2005: package list
SELECT name
     , description
     , CASE
           WHEN packagetype = 0 THEN 'default client'
           WHEN packagetype = 1 THEN 'SQL Server Import and Export Wizard'
           WHEN packagetype = 2 THEN 'DTS Designer in SQL Server 2000'
           WHEN packagetype = 3 THEN 'SQL Server Replication'
           WHEN packagetype = 5 THEN 'SSIS Designer'
           WHEN packagetype = 6 THEN 'Maintenance Plan Designer'
           ELSE 'Unknown'
       END packagetype
FROM msdb.dbo.sysdtspackages90
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s