How can I change DTS owner -- sql server dts

Brian
9/20/2004 9:35:02 AM

Another user with the correct permissions should be able to do a Save As on
the package to change ownership.

Hope this helps,
Brian

[quoted text, click to view]

Mike Anderson
9/20/2004 2:29:19 PM

Yes - Change as needed:
sp_changeobjectowner 'mike.testing123',dbo

[quoted text, click to view]

Paul Robinson
9/20/2004 3:08:45 PM

I have written a whole series of DTS packages for a client that I wish to
schedule though SQL Server Agent. However, they were written in my name,
with my logon as the owner and I do not have the necessary permissions
within Agent. Nor am I being given them. Instead of rewriting all the
packages in another user's name, is there any way that I can change the
owner of the package to someone who does have rights?

Allan Mitchell
9/20/2004 7:05:11 PM

[quoted text, click to view]

You can have a look at this article but in general the owner of a package is a
non event.

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

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 about sql server dts

sql server dts : How can I change DTS owner