Get the SSIS Package name from SSIS Package store where a specific object is used
SELECT a.name,
CONVERT(XML, CONVERT(VARBINARY(MAX), a.packagedata)) AS ssispackagexml
FROM msdb.dbo.sysssispackages a (nolock)
WHERE CAST(CONVERT(XML, CONVERT(VARBINARY(MAX), a.packagedata)) AS
NVARCHAR(MAX)) LIKE
'%objectname%'
SELECT a.name,
CONVERT(XML, CONVERT(VARBINARY(MAX), a.packagedata)) AS ssispackagexml
FROM msdb.dbo.sysssispackages a (nolock)
WHERE CAST(CONVERT(XML, CONVERT(VARBINARY(MAX), a.packagedata)) AS
NVARCHAR(MAX)) LIKE
'%objectname%'
No comments:
Post a Comment