sql server dts: Save over othr onwers DTS -- sql server dts

Save over othr onwers DTS

Wendy
9/21/2004 3:03:16 AM

sql server dts:

Hiya,

What I want to do is be able to save over another users
DTS package where their username is the owner.

I dont want to have to 'save as' a different name then
delete the original and rename my one, as there is quite a
lot to do.

Is there specific permissions I can get granted to allow
me to overwrite someone else's DTS package except
sysadmin??

Thanks

Re: Save over othr onwers DTS

Sue Hoegemeier
9/21/2004 6:28:23 AM

You can find information on the topic and ways to change the
package owner in the following article on sqldts.com:
Package Ownership Issues
http://www.sqldts.com/default.aspx?212

-Sue

On Tue, 21 Sep 2004 03:03:16 -0700, "Wendy"
[quoted text, click to view]

Re: Save over othr onwers DTS

Darren Green
9/21/2004 12:47:37 PM

In message <083f01c49fc2$36965470$a601280a@phx.gbl>, Wendy
<anonymous@discussions.microsoft.com> writes
[quoted text, click to view]

You could hack the sp_add_dtspackage stored procedure to remove the
sysadmin role check. This works for me on all dev boxes where developers
need to co-author packages, yet they are not always sysadmins.

If you can delete the original, then open it, delete the original, then
save again. Enterprise Manager will keep the "open" package in memory
for you. Not ideal, but faster than the Save As times two.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.