Execution table in SSISDB

Store the executed package Information

SELECT [execution_id]       ,[folder_name]       ,[project_name]       ,[package_name]       ,[reference_id]       ,[reference_type]       ,[environment_folder_name]       ,[environment_name]       ,[project_lsn]       ,[executed_as_sid]       ,[executed_as_name]       ,[use32bitruntime]   FROM [SSISDB].[internal].[executions]

  

Execution ID

This is an auto generated id.

Reference ID

The environment that is referenced by the instance of execution. I mean if we are using the environment in the package the environment id will be capture in this column.

Select e.execution_id,e.package_name, e.project_name,e.reference_id, e.environment_folder_name,e.environment_name FROM [SSISDB].[internal].[executions] e INNER Join [SSISDB].[internal].[environments] env on Env.environment_id=e.reference_id

   

Same we can see in SSISDB integration catalog

  

Note: If our server is running shortage of space we can truncate this table. It will not affect our operation. Here we are store only package executing details.