Biml and SSIS Frameworks - SQL Server Integration Services Design Patterns - page 529

(@AppID, GetDate(), 'Running')
go
print 'Log.LogStartOfApplication stored procedure
created.'
print ''
/* log.LogApplicationSuccess stored procedure */
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 = 'log'
And p.name = 'LogApplicationSuccess')
begin
print 'Dropping log.LogApplicationSuccess stored
procedure'
Drop Procedure [log].LogApplicationSuccess
print 'Log.LogApplicationSuccess stored procedure
dropped'
end
print 'Creating log.LogApplicationSuccess stored
procedure'
go
Create Procedure [log].LogApplicationSuccess
@AppInstanceID int
As
update log.SSISAppInstance
set EndDateTime = GetDate()
, Status = 'Success'
where AppInstanceID = @AppInstanceID
go
print 'Log.LogApplicationSuccess stored procedure
created.'
print ''
/* log.LogApplicationFailure stored procedure */