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

end
Else
print 'Log.SSISEvents table already exists.'
print ''
/* log.LogEvent 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 = 'LogEvent')
begin
print 'Dropping log.LogEvent stored procedure'
Drop Procedure [log].LogEvent
print 'Log.LogEvent stored procedure dropped'
end
print 'Creating log.LogEvent stored procedure'
go
Create Procedure [log].LogEvent
@AppInstanceID int
,@PkgInstanceID int
,@SourceName varchar(255)
,@EventDescription varchar(max)
As
insert into [log].SSISEvents
(AppInstanceID, PkgInstanceID, SourceName,
EventDescription)
Values
(@AppInstanceID
,@PkgInstanceID
,@SourceName
,@EventDescription)
go
print 'Log.LogEvent stored procedure created.'
print ''