Is there a way to change the ownership of a dts package
without having to do a "save as" with a different name?
The packages are scheduled as jobs (with multiple steps in
the job) and each job would have to be recreated as well.
Any help would be appreciated. Thank you.

In table sysdtspackages on msdb, you have a column called owner_SID. This
can be changed to change package owner.

Pete

"Laura Reynolds" <lreynolds (AT) dialamerica (DOT) com> wrote

There is also a stored procedure called sp_reassign_dtspackageowner that can
be used to achieve this.

Pete

"Laura Reynolds" <lreynolds (AT) dialamerica (DOT) com> wrote

Pete,
Thanks for the quick response. I found that I can also
change the owner of the job (without changing the dts
ownership) and the job runs successfully.
Laura

Here is one way

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

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Laura Reynolds" <lreynolds (AT) dialamerica (DOT) com> wrote

In article <eJ1rjRFfDHA.2072 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Peter Hall
<pete_ha11 (AT) hotmail (DOT) com> writes
Pete, be aware that this is only a temporary fix, as the information you
see in sysdtspackages is a really a copy of what is in the object model.
When you next save the package the sydtspackages information is
redundant since a new row will be written, based on the object model, so
the owner change you made is now lost.

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

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