Hi @Shambhu Rai,
Check below code to see if it is helpful.
Use SSISDB
select
prj.name as 'ProjectName'
,pa.name as 'SSISPackageName'
,op.parameter_name as 'ParmaterName'
,op.design_default_value as 'ConnectionString'
from
catalog.object_parameters op
join catalog.projects prj
on op.project_id = prj.project_id
join [catalog].[packages] pa
on pa.project_id = prj.project_id
where op.parameter_name like '%ConnectionString%'
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.