we have several SSIS-packages on our SQL servers, usually stored in the msdb. In these packages you find "execute sql"-tasks as well as other tasks using T-SQL-statements.
We have to change some tables in our database and need to know if they are used in the SSIS-packages. Unfortunately some of the packages are quite old and do not use stored procedures for data access but ad hoc queries.
Is there a way to get this information without writing a C# program?
I wonder if the ssis package tasks and their properties are stored somewhere in the system tables so I can query these properties using T-SQL.
Thank's a lot, WolfgangE