SSIS pkg ID to SSIS pkg Name

• BI_Developer

  SSC Eights!

  Points: 908

  More actions

  October 21, 2016 at 9:01 am

  #318292

  I need to identify what the name of specific ssis packages are when I only have an ssis id i.e. SSIS-Package-{37F83E14-374C-480E-AF01-F7ECB5E0C9B6}

  Also, does someone have a script that I can use to identify when a table is upated by a sproc. Also, when a table or sproc is used in a ssis pckg or sQL job.

  Thanks,

  J.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  October 21, 2016 at 1:29 pm

  #1908096

  BI_Dev (10/21/2016)

  ---

  I need to identify what the name of specific ssis packages are when I only have an ssis id i.e. SSIS-Package-{37F83E14-374C-480E-AF01-F7ECB5E0C9B6}

  J.

  Try querying sysssispackages in msdb.

  Sue

• Phil Parkin

  SSC Guru

  Points: 246960

  More actions

  October 21, 2016 at 1:36 pm

  #1908099

  Sue_H (10/21/2016)

  ---

  BI_Dev (10/21/2016)

  ---

  I need to identify what the name of specific ssis packages are when I only have an ssis id i.e. SSIS-Package-{37F83E14-374C-480E-AF01-F7ECB5E0C9B6}

  J.

  Try querying sysssispackages in msdb.

  Sue

  And Catalog.Packages in SSISDB.

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin