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