Database Reference
In-Depth Information
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
= 'execute_catalog_package_with_data_tap')
begin
print ' - Dropping
custom.execute_catalog_package_with_data_tap'
Drop Procedure
custom.execute_catalog_package_with_data_tap
print '
- Custom.execute_catalog_package_with_data_tap dropped'
end
/* Create the
Custom.execute_catalog_package_with_data_tap Stored
Procedure */
print ' - Creating
custom.execute_catalog_package_with_data_tap'
go
/*
Stored Procedure:
custom.execute_catalog_package_with_data_tap
Author: Andy Leonard
Date: 4 Apr 2012
Description: Creates a wrapper around the SSISDB Catalog
procedures
used to start executing an SSIS Package and
create a
data tap. Packages in the
SSIS Catalog are referenced by a multi-part
identifier
- or path - that consists of the following
hierarchy:
Search WWH ::
Custom Search