How to Change the Owner of a DTS package? | SansSQL

Saturday, May 3, 2008

How to Change the Owner of a DTS package?

USE MSDB
sp_reassign_dtspackageowner [@name =] 'name', [@id =] 'id', [@newloginname =] 'newloginname'

sp_reassign_dtspackageowner is an undocumented stored procedure which is present in MSDB database.

Ads