Execution Patterns - SQL Server Integration Services Design Patterns - page 68

run as part of the SSIS Application.
Description: Links an SSIS Package to an SSIS
Application
Example: exec custom.AddApplicationPackage 1,
1, 10, 1
*/
Create Procedure custom.AddApplicationPackage
@ApplicationID int
,@PackageID int
,@ExecutionOrder int = 10
,@ApplicationPackageEnabled bit = 1
As
begin
Set NoCount On
Insert Into custom.ApplicationPackage
(ApplicationID
,PackageID
,ExecutionOrder
,ApplicationPackageEnabled)
Values
(@ApplicationID
,@PackageID
,@ExecutionOrder
,@ApplicationPackageEnabled)
end
go
print ' - Custom.AddApplicationPackage Stored Procedure
created.'
print ''
Create a new SSIS Package in the Chapter2 project and rename it Parent.dtsx .
Click the Parameters tab on the package—it's the third tab from the left (Control Flow,
Data Flow, Parameters). Click the Add Parameter button and create a parameter named