title: SSIS - How to Identify which package a row in the log table is referring to?
body: <p>I have multiple SSIS integration packages logging to a database.  They all write to the table sysssislog.</p>
  
  <p>I want a stored procedure to be able to return the success of the last run of a selected package.</p>
  
  <p>How do I identify a package in sysssislog?  The executionid field would seem to work, but it seems like it's changing values on mosts runs of the same package (sometimes it stays the same).  Is there some way to know which package a log entry is coming from?</p>
  
  <p>Structure of sysssislog for reference:</p>
  
  <pre><code>CREATE TABLE [dbo].[sysssislog](
      [id] [int] IDENTITY(1,1) NOT NULL,
      [event] [sysname] NOT NULL,
      [computer] [nvarchar](128) NOT NULL,
      [operator] [nvarchar](128) NOT NULL,
      [source] [nvarchar](1024) NOT NULL,
      [sourceid] [uniqueidentifier] NOT NULL,
      [executionid] [uniqueidentifier] NOT NULL,
      [starttime] [datetime] NOT NULL,
      [endtime] [datetime] NOT NULL,
      [datacode] [int] NOT NULL,
      [databytes] [image] NULL,
      [message] [nvarchar](2048) NOT NULL,
  </code></pre>