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

From sys.procedures p
Join sys.schemas s
On s.schema_id = p.schema_id
Where s.name = 'custom'
And p.name = 'AddApplicationPackage')
begin
/* If custom.AddApplicationPackage stored procedure
exists, drop it */
print ' - Dropping custom.AddApplicationPackage Stored
Procedure'
Drop Procedure custom.AddApplicationPackage
print ' - custom.AddApplicationPackage Stored Procedure
dropped'
end
print ' - Creating custom.AddApplicationPackage Stored
Procedure'
go
/*
Procedure: custom.AddApplicationPackage
Author: Andy Leonard
Parameter(s): ApplicationID [int]
- contains the ID returned from the
execution
of custom.AddApplication.
PackageID [int]
- contains the ID returned from the
execution
of custom.AddPackage.
ExecutionOrder [int]
- contains the order the package will
execute
within the SSIS Application.
ApplicationPackageEnabled [bit]
- 1 == Enabled and will run as
part of the SSIS Application.
0 == Disabled and will not