source file path/db name ssis

Question

Hi Expert,

how to get db name or source file path from packages

for an example

Answer 1

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.

Answer 2

how to get db name or source file path from packages

What for DB name or source file from which package?

from packages

Open the package in SSDT and lookup the connection manager for details.