• If you have the packages stored in the SQL Server then you could do something like this:

    SELECT Name, CONVERT(xml,CONVERT(varbinary(max),PackageData)) AS PackageSource

    FROM msdb.dbo.sysssispackages

    WHERE CONVERT(varbinary(max),PackageData) LIKE '%Your Table Name%'

    It's a bit of a hack but it should work.

    If they are stored in the filesystem then you would have to search the package xml.

    Hope that helps 🙂


    I'm on LinkedIn