SSIS Package Connection String

SSIS Package Connection String

WITH Packages
AS (
       SELECT DISTINCT CAST([parameter_value] AS VARCHAR(1000)) AS Parameter_value
                ,ei.package_name
                ,ei.project_name
                ,ei.folder_name
         FROM [SSISDB].[internal].[execution_parameter_values] v
         INNER JOIN SSISDB.internal.execution_info ei
              ON ei.execution_id = v.execution_id
         WHERE parameter_name Like '%Connection%'
         AND parameter_data_type = 'string')
SELECT *
FROM Packages
WHERE Parameter_value LIKE '%Audit%'