DTS PACKAGE OWNERSHIP CHANGE

Can someone please tell me how to easily change the
ownership of a DTS package from the person who created
them to any other login on the server? Thank you.
RandaIn message <1f9501c3e103$6464b960$a301280a@.phx.gbl>, Randa
<anonymous@.discussions.microsoft.com> writes

quote:

---

>It worked just fine and I really appreciate. However, I
>was hoping to do several at a time, I tried it with the IN
>operator and it didn't work - I had an "Incorrect syntax
>near the keyword 'in'" Is there a way of doing more than
>one at a time? Thank you
>Here is my script:
>Exec sp_reassign_dtspackageowner
>@.name in ('NewaPackDB','clientDB'),
>@.id in ('C2C1BBD2-73...','C2C1BBD2-73...'),
>@.newloginname = 'BA\adm'
>

---

There is a script here that does this, but please read the limitations
of this. It is only temporary as it doesn't change the owner in the
underlying package object.
Package Ownership Issues
(http://www.sqldts.com/default.aspx?212)
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org