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

print ''

/* Build custom.AddPackage stored procedure */
print 'Custom.AddPackage'
If Exists(Select s.name + '.' + p.name
From sys.procedures p
Join sys.schemas s
On s.schema_id = p.schema_id
Where s.name = 'custom'
And p.name = 'AddPackage')

begin
/* If custom.AddPackage stored procedure
exists, drop it */
print ' - Dropping custom.AddPackage Stored Procedure'
Drop Procedure custom.AddPackage
print ' - custom.AddPackage Stored Procedure dropped'
end
print ' - Creating custom.AddPackage Stored Procedure'
go

/*

Procedure: custom.AddPackage
Author: Andy Leonard
Parameter(s): FolderName [nvarchar(128)]
- contains the name of the SSISDB Catalog
folder containing the SSIS

Package.

ProjectName [nvarchar(128)]
- contains the name of the SSISDB Catalog
project containing the SSIS

Package.

PackageName [nvarchar(128)]
- contains the name of the SSISDB Catalog
SSIS Package.
PackageDescription

[nvarchar(512)]

- contains a description of