InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 15:27:02 GMT20http://www.sqlservercentral.com/Forums/Topic1406581-392-1.aspxThank's a lot. I already found this table but I did not realize that the one column contains the whole package. The hint of queries built at rune time is a good one too. :-)Mon, 14 Jan 2013 07:39:16 GMTWolfgangEhttp://www.sqlservercentral.com/Forums/Topic1406581-392-1.aspxThe SSIS package definitions are stored in msdb.dbo.sysssispackages. Because the definition is XML you can cast it to the XML data type and then operate on it using XQuery. A carefully crafted query could deliver you all the SQL Statements contained in every package. However, many times SSIS developers will use Variables and Expressions to build SQL statements at runtime so I would recommend you only view the information in the table as an initial discovery tool and not the authoritative answer as to whether something will be impacted by a change.[code="sql"]SELECT CAST(CAST(CAST([packagedata] AS VARBINARY(MAX)) AS VARCHAR(MAX)) AS XML) AS xml_package_definition, *FROM msdb.dbo.sysssispackagesWHERE CAST(CAST([packagedata] AS VARBINARY(MAX)) AS VARCHAR(MAX)) LIKE '%%';[/code]Mon, 14 Jan 2013 07:28:18 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1406581-392-1.aspxHi there,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, WolfgangEMon, 14 Jan 2013 00:48:10 GMTWolfgangE