sql server dts: Change DTS Package Owner without being in Sysadmin Role -- sql server dts

Change DTS Package Owner without being in Sysadmin Role

carlos NO[at]SPAM eddorre.com
10/29/2004 4:42:44 PM

sql server dts: I've seen this question around the newsgroups so I thought that I
would post my soltuion to it. The undocumented stored procedure
sp_reassign_dtspackageowner works fine if you are in the System
Administrator server role but it's not very good for allowing, say,
developers to change the owner of a package while not giving them full
access to the server.

Here is my solution:

Re: Change DTS Package Owner without being in Sysadmin Role

Darren Green
11/2/2004 9:31:43 AM

I think this is solving the symptom not the root problem, and it is only
tempoary as a new save will change it back again.. The owner is not used
anywhere, apart from some checks in the save DTS procedures, so why not
change these instead.

Package Ownership Issues
(http://www.sqldts.com/default.aspx?212)

--
Darren Green
http://www.sqldts.com

[quoted text, click to view]