Hi, I am a system administrator and I tried using sp_changeobjectowner to change the owner of a local dts package and it won't let me. Is there another way to change a local package owner in EM or QA? Thanks!

sp_changeobectowner won't work for packages. Often time you
don't really need to worry about the package owner. You can
find more information on the topic and methods you can use
to change the owner in the following article on sqldts.com:
Package Ownership Issues
http://www.sqldts.com/default.aspx?212

-Sue

On Tue, 27 Apr 2004 06:41:03 -0700, jill johnson
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Have a look here

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.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"jill johnson" <anonymous (AT) discussions (DOT) microsoft.com> wrote

another way to change a local package owner in EM or QA? Thanks!

The only way to have a change in a DTS package owner to persist is to save
the DTS package as a structured storage file, log in as the user who you
want to own the package, open the package and save it (with a different
name).

Rand
This posting is provided "as is" with no warranties and confers no rights.