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

go
/*
Procedure: custom.AddApplication
Author: Andy Leonard
Parameter(s): ApplicationName [nvarchar(256)]
- contains the name of the SSIS Application
to add to the Framework
database.
ApplicationDescription
[nvarchar(512)]
- contains a description of
the SSIS Application.
Description: Stores an SSIS Application.
Example: exec custom.AddApplication
'TestSSISApp', 'A test SSIS Application.'
*/
Create Procedure custom.AddApplication
@ApplicationName nvarchar(256)
,@ApplicationDescription nvarchar(512) = NULL
As
begin
Set NoCount On
Insert Into custom.Application
(ApplicationName
,ApplicationDescription)
Output inserted.ApplicationID
Values
(@ApplicationName
,@ApplicationDescription)
end
go
print ' - Custom.AddApplication Stored Procedure created.'