SSISDB - Can I get Data Lineage?

Question

We will be converting from SSIS packages stored on file system, to using SSISDB. I have been asked what amount of data lineage and metadata we will be able to obtain from the SSISDB database.

I found some information in SSISDB.[internal].[event_message_context], such as connection manager names, but not lineage. I'm assuming it will require a 3rd-party tool, but am looking for confirmation.

Answer 1

Hi @alhowarthWF ,

Please use the following sql query to get the connection string of connection manager.

SELECT TOP (1000) [execution_parameter_id]  
      ,[execution_id]  
      ,[object_type]  
      ,[parameter_data_type]  
      ,[parameter_name]  
      ,[parameter_value]  
      ,[sensitive]  
      ,[required]  
      ,[value_set]  
      ,[runtime_override]  
  FROM [SSISDB].[catalog].[execution_parameter_values] order by [execution_parameter_id] desc;  

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.