We are trying to catch errors into an Error Log Table, similar to below. We have many Master SSIS packages, calling many stored procedures.
Following code will log into the Error Log Table. Is there a SQL reserved keyword to find the SSIS package which executed the stored procedure?
insert into dbo.ErrorLogData ( ErrorNumber ,ErrorDescription ,ErrorProcedure ,ErrorState ,ErrorSeverity ,ErrorLine ,ErrorTime ,SSISPackage --??? ) VALUES ( ERROR_NUMBER() ,ERROR_MESSAGE() ,ERROR_PROCEDURE() ,ERROR_STATE() ,ERROR_SEVERITY() ,ERROR_LINE() ,GETDATE() -- what is reserved keyword for SSIS package? );