Change DTS package owner

Create Procedure sp_reasign_dts_packages 
(
@owner varchar(255),
@newowner varchar(255), 
@package_name varchar(1000) = null
)

as


/*

--Test

declare @owner varchar(255),
@newowner varchar(255), 
@package_name varchar(1000)

set @owner = 'Bob'
set @newowner = 'Jim'
set @package_name = NULL
*/
if @package_name is null 
begin
update 
msdb.dbo.sysdtspackages 
set 
owner = @newowner, 
owner_sid = suser_sid(@newowner) 
where 
owner_sid = suser_sid(@owner)
end
else
begin
update 
msdb.dbo.sysdtspackages 
set 
owner = @newowner, 
owner_sid = suser_sid(@newowner) 
where 
owner_sid = suser_sid(@owner) and
[name] = @package_name
end