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

-- Build ApplicationPackage --
Select @ExecutionOrder = 10
,@ApplicationPackageEnabled = 1
Exec custom.AddApplicationPackage
@ApplicationID
,@PackageID
,@ExecutionOrder
,@ApplicationPackageEnabled
Delete @PackageTbl
-- Build Package --
Select @FolderName = 'Chapter2'
,@ProjectName = 'Chapter2'
,@PackageName = 'Chapter2.dtsx'
,@PackageDescription = 'Another test SSIS package'
Insert Into @PackageTbl
Exec custom.AddPackage
@FolderName
,@ProjectName
,@PackageName
,@PackageDescription
Select @PackageID = PackageID
From @PackageTbl
-- Build ApplicationPackage --
Select @ExecutionOrder = 20
,@ApplicationPackageEnabled = 1
Exec custom.AddApplicationPackage
@ApplicationID
,@PackageID
,@ExecutionOrder
,@ApplicationPackageEnabled