title: Using T-SQL to get the SSIS Package name, job name and description
body: <p>I'm trying to get the following information out of SQL Server:</p>
  
  <ul>
  <li>All SSIS Jobs Agent Names.</li>
  <li>SSIS Package Name.</li>
  <li>[optional but nice to have] SSIS Job agent description.</li>
  </ul>
  
  <p>I'm able to pull all 3 of these pieces of information with no problems using the following tables:</p>
  
  <ul>
  <li>msdb.dbo.sysjobs gives me the Job name and Job description.</li>
  <li>msdb.dbo.sysssispackages gives me the SSIS Package name.</li>
  </ul>
  
  <p>Unfortunately I'm not able to find a correlation between those 2 tables to gets me all 3 pieces of information together.</p>
  
  <p>Any ideas?  Thanks!</p>