we are using Microsoft SQL Server 2017 Enterprise Edition in a cluster.
I also look for my dtsx packages in the msdb.dbo.sysdtspackages system table, but they cannot be found there.
Are these not saved in the cluster?
I want to list packages in which tables and stored procedures are used. The Integration Service Catalog contains hundreds of projects that contain many packages.
How or where can I therefore retrieve the metadata?
I have already searched the WEB and found nothing except for this article. Unfortunately the last answer is already 10 years old.
Who has an idea.
I am currently exporting the projects (ispac files) from the Integration Service catalog and unpacking them. With Notepad ++ search the dtsx packages with the search function in text files.
After the 10th project and a lot of packages, I don't feel like it anymore and am looking for a simple solution.
Thanks in advance.