How can I change DTS owner

#1

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?

#2

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

Hope this helps,
Brian

"Paul Robinson" wrote:

Quote:

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?

#3

In article <#kPMXtxnEHA.3820 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Paul Robinson wrote:

Quote:

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?

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

#4

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

Quote:

-----Original Message-----
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?

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How can I change DTS owner

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How can I change DTS owner - 09-20-2004 , 09:08 AM

RE: How can I change DTS owner - 09-20-2004 , 11:35 AM

Re: How can I change DTS owner - 09-20-2004 , 02:05 PM

How can I change DTS owner - 09-20-2004 , 04:29 PM