Changing the Owner of a DTS Package

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  January 3, 2008 at 10:25 am

  #69404

  Hello All

  Happy New Year!

  Is it possible to change the owner of a DTS Package? I have created some and they have my username as the owner. In one of them, I have a file being placed on a share. But I do not want this to happen under my username. We have non-human accounts to transport data like this.

  I mean, what happens when I leave, and then my active directory account is removed? What account will then be owner of the package? And the permissions set on the directory where the file is being placed will not work.

  I need to either create a new package, or be able to modify the current one to allow me to select the owner that I want.

  Thanks

  Andrew

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  January 3, 2008 at 10:43 am

  #764485

  Did you try this one?

  UPDATE msdb..sysdtspackages SET owner = 'sa' WHERE name = 'PackageName'

  Or you may try

  DECLARE @sql VARCHAR(1000)

  SELECT @sql = 'EXEC sp_reassign_dtspackageowner ''' + name + ''', ''' + CAST(id AS VARCHAR(10)) + ''', ''' + new_owner + ''''

  FROM sysdtspackages

  WHERE name = ' '

  EXEC (@SQL)

  id is the ID of your DTS package.