Re: how to change dts owner name

#1

Using sp_changeobjectowner won't work. You can use the
undocumented sp_reassign_dtspackageowner. You can find
information on package ownership issues at:
http://www.sqldts.com/default.aspx?212

-Sue

On Thu, 30 Sep 2004 17:12:12 -0700, "JJ Wang"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Quote:

hi,

does anyone know how to change a dts packeage's owner name
on sql 2000?

we have individuals that creates dts packages on
production servers, and we would like to change the dts
owner name from the individual accounts into server's own
account name.

many thanks!

JJ

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

Re: how to change dts owner name

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

Re: how to change dts owner name - 09-30-2004 , 08:52 PM