Database Reference
In-Depth Information
And p.name = 'GetApplicationPackages')
begin
/* If custom.GetApplicationPackages stored procedure
exists, drop it */
print ' - Dropping custom.GetApplicationPackages Stored
Procedure'
Drop Procedure custom.GetApplicationPackages
print ' - custom.GetApplicationPackages Stored
Procedure dropped'
end
print ' - Creating custom.GetApplicationPackages Stored
Procedure'
go
/*
Procedure: custom.GetApplicationPackages
Author: Andy Leonard
Parameter(s): ApplicationName [nvarchar(256)]
- contains the name of the SSIS Application
for which to retrieve SSIS
Packages.
Description: Executes against the
custom.ApplicationPackages
table joined to the custom.Application
and custom.Packages
tables. Returns a
list of enabled Packages
related to the
Application ordered by
ExecutionOrder.
Example: exec custom.GetApplicationPackages
'TestSSISApp'
*/
Create Procedure custom.GetApplicationPackages
@ApplicationName nvarchar(256)
As
Search WWH ::
Custom Search