Hi everyone I am trying to obtain some extra information from my ssis packages but I am not getting anywhere. I am using two tables to obtain some information from them. The tables are:
But I have found this post that says that the tables sysssispackages and sysssispackagefolders exist, which version of sql server are you guys using? Any opinion is welcome. Thanks!!!!
Here is the query that I ended up using. Run this, then copy the results to a batch file:
from msdb.dbo.sysssispackages pkg
join msdb.dbo.sysssispackagefolders fld