title: Execution time of ETL packages - script
body: <p>I use below script to calcute execution time of ETL packages:</p>
  
  <pre><code>DECLARE @DATE DATE = GETDATE() - 7
  
  SELECT
        [folder_name]
        ,[project_name]
        ,[package_name]
        ,CAST([start_time] AS datetime) AS [start_time]
        ,DATEDIFF(minute, [start_time], [end_time]) AS 'execution_time[min]'
  FROM [SSISDB].[internal].[execution_info]
  WHERE start_time &gt;= @DATE
  ORDER BY [start_time] 
  </code></pre>
  
  <p>It's possible to increase level of granularity? I would like to have execution time of each ETL blocks.</p>