query ssis package store packages

SELECT [name]
,[id]
,[description]
,[createdate]
,CAST(CAST([packagedata] as varbinary(max)) as xml) AS PackageSource
,[packagetype]
,[vermajor]
,[verminor]
,[verbuild]
,[vercomments]
,[verid]
,[isencrypted]
FROM [msdb].[dbo].[sysssispackages]

WHERE CAST(CAST([packagedata] as varbinary(max)) as VARCHAR(MAX)) LIKE ‘%search_criteria%’

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


%d bloggers like this: