Change owner of an SSIS package

Question

I need to change the owner of an SSIS package. For some reason a developer created a package that is listed as
<developer name>.Packagename.  I'd lke to subsitute "dbo" for <developer name>

TIA,

barkingdog

Answer 1

Hello,

You need to look at the below tables and update the ownersid column. Below is teh code snippet to do that.

--SQL Server 2005
select * from msdb.dbo.sysdtspackages90
--SQL Server 2008
select * from msdb.dbo.sysssispackages


UPDATE msdb.dbo.sysssispackages 
SET [ownersid] = SUSER_SID('sa') 
WHERE [name] = 'MaintenancePlan' 

You may want to cacth up on this post by Jonathan.

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/05/04/dyk-maintenance-plans-have-owners.aspx

---

| Sankar Reddy | http://sankarreddy.spaces.live.com/ |

Answer 2

Even now after all these years, this is still helpful as I used it to update several SSIS packages.