Search code examples
sqlsql-serverssisintegrationdatabase-administration

SSIS package dependent objects on SQL Server

I need to create a localized environment for a SSIS package that would only have the objects and entities needed by tasks inside it.

It's a large & complex SSIS package and it connects to eight databases on the same sql server.

Is there a quick way to list all the tables, stored procedures, functions etc that will be utilized(directly or indirectly) when I execute this package.

Solution

  • Good thought by Nick, but even that will only get you objects that are used directly. There is no quick easy way to get all the objects that will be used indirectly.