How to Create a Relationship Between Two Packages in SSIS
Microsoft's SQL Server Integration Service (SSIS) provides you with a designer you use to create packages that run SQL statements using a scheduler. To create a relationship with another package within your own package, you add an event handler and point execution to the external package. This means you can execute other SQL statements in another package without rewriting the statements.
Other People Are Reading
Instructions
-
-
1
Open the SQL Server Management Studio software on your SSIS server. Log in to your database. Double-click the SSIS package you want to edit.
-
2
Click the "Event Handlers" tab in the designer. Drag and drop a "Task" object from the toolbox to the designer. Click the task to activate it.
-
-
3
Select the package name from the "Executable" drop-down. In the "Handler" drop-down, select "OnExecute."
-
4
Click the "Save" button. Click "Run" to execute the SSIS package and test the new settings.
-
1
