SSIS package calls SSIS package

An SSIS package can call other SSIS packages, and under the common classification in SSIS Tools, there is a component Execute Package Task that uses the component to invoke and execute other packages in one package.

In the SSIS package properties, there are two ways to set the path to the reference package, one in the packages, set Referencetype and Packagenamefromprojectreference, One is to set the property expressions in expressions to refer to the package.

The first way:

Referencetype, if you are in the same project, select Project Reference.

Packagenamefromprojectreference is the name of the package in the project.

If you are not in the same project, then referencetype Check external Reference, there are two ways to refer to packages, if the package has been published to SQL Server, then you can directly reference, only need to create a connection, You can get the package from SQL Server, and if the package is not published in SQL Server and is called by the file system, you must create a file connection to link to the package.

The second way: dynamically set the path of the package, check the Prockagename property, select a custom parameter or variable in expression to provide the package name

If the called package needs to pass parameters, it can be set in parameter bindings.

SSIS package calls SSIS package