Advertisement
jamiet

vevent_messages for SSIS

May 16th, 2012
170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.31 KB | None | 0 0
  1. CREATE VIEW [catalog].[vevent_messages]
  2. AS
  3. SELECT  em.[operation_id],em.[event_message_id],em.[event_name],em.[message_time],em.[message],em.[execution_path],em.[package_name],em.[message_source_name],em.[package_path]
  4. FROM    [catalog].[event_messages] em
  5. WHERE   em.[event_name] NOT IN ('OnPreValidate','OnPostValidate')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement