How to use ownersid column value of sysdtspackages90 system table

• Mike-448558

  SSC Eights!

  Points: 985

  More actions

  October 19, 2009 at 3:47 pm

  #385607

  Does someone know which system table or system view can be used to link with the ownersid column of sysdtspackages90 to identify the creator of an SSIS package.

  Example:

  SELECT *

  FROM msdb.dbo.sysusers

  WHERE sid = (SELECT ownersid

  FROM msdb.dbo.sysdtspackages90

  WHERE name = 'SSIS_Package_Name')

  The subquery returns a value.

  But the main query does not.

  Thanks

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  October 19, 2009 at 9:04 pm

  #1067927

  SELECT

  name, description,suser_sname(ownersid)

  FROM

  msdb.dbo.sysdtspackages90

  Try the above code from http://sqlblogcasts.com/blogs/acalvett/.

  MJ