SSIS package path

• goyal.bhoomika

  SSC Veteran

  Points: 294

  More actions

  March 10, 2008 at 10:07 am

  #154185

  Hi,

  I need to find the path/location at which the SSIS package that`s executing is stored.

  How do I do that???

  Thanks and Regards,

  Bhoomika

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  March 10, 2008 at 11:07 am

  #787505

  select b.foldername, a.name

  from msdb.dbo.sysdtspackages90 a with(nolock)

  join msdb.dbo.sysdtspackagefolders90 b with(nolock)

  on a.folderid = b.folderid

  Tommy

  Follow @sqlscribe

• goyal.bhoomika

  SSC Veteran

  Points: 294

  More actions

  March 12, 2008 at 3:04 am

  #788423

  Hi,

  Thanks for the reply.

  I used the query but the foldername comes blank.

  Any suggestions???

  Thanks and Regards,

  Bhoomika

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  March 12, 2008 at 5:45 am

  #788478

  If the folder returns black then the package is likely stored at the root - i.e. /PackageName. You can connect to the SSIS instance via management studio and verify this as well.

  Tommy

  Follow @sqlscribe