CREATE PROCEDURE sp_enum_dtssteplog
  @lineagefull		UNIQUEIDENTIFIER = NULL,	-- all steps in this package execution
  @stepexecutionid	BIGINT = NULL
AS
  SET NOCOUNT ON

  --// This is used for realtime viewing of package logs, so don't error if no entries
  --// found, simply return an empty result set.
  --// This query must be restricted within a single package execution (lineage); it may
  --// be further restricted by stepexecutionid to a single step within that package execution.
  SELECT
    stepexecutionid,
    lineagefull,
    stepname,
    stepexecstatus,
    stepexecresult,
    starttime,
    endtime,
    elapsedtime,
    errorcode,
    errordescription,
    progresscount
  FROM sysdtssteplog
  WHERE (@lineagefull IS NULL OR lineagefull = @lineagefull)
    AND (@stepexecutionid IS NULL OR stepexecutionid = @stepexecutionid)
  ORDER BY stepexecutionid

  RETURN 0    -- SUCCESS

GO
 

 
Server: Msg 213, Level 16, State 7, Procedure sp_enum_dtssteplog, Line 11
Insert Error: Column name or number of supplied values does not match table definition.

--------
DROP TABLE #dtsStepLog

SELECT
    stepexecutionid,
    lineagefull,
    stepname,
    stepexecstatus,
    stepexecresult,
    starttime,
    endtime,
    elapsedtime,
    errorcode,
    errordescription,
    progresscount
INTO #dtsStepLog
FROM msdb.dbo.sysdtssteplog

TRUNCATE TABLE #dtsStepLog

INSERT #dtsStepLog EXEC msdb.dbo.sp_enum_dtssteplog null, null