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 the msdb database there is stored procedure named
sp_reassign_dtspackageowner that will do the trick. Here's
some sample syntax:
msdb..sp_reassign_dtspackageowner
@.name = 'Package Name',
@.id = 'FF18ACDD-3FBF-48FF-8E1D-0CE4038D5EE4',
@.newloginname = 'sa'
You can obtain the package ID (@.id) from the
msdb..sysdtspackages table (ID column).
EXAMPLE:
First get the id:
Select id from dbo.sysdtspackages
where name = 'MYDTSPACKAGE'
GO
Adjust the syntax
Exec sp_reassign_dtspackageowner
@.name = 'MYDTSPACKAGE',
@.id = 'D72333A2-7DED-11D4-BF04-00B0D057DBE4',
@.newloginname = 'Userid'
Hope it helps......
>--Original Message--
>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.
>Randa
>.
>|||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'
>--Original Message--
>In the msdb database there is stored procedure named
>sp_reassign_dtspackageowner that will do the trick.
Here's
>some sample syntax:
>msdb..sp_reassign_dtspackageowner
>@.name = 'Package Name',
>@.id = 'FF18ACDD-3FBF-48FF-8E1D-0CE4038D5EE4',
>@.newloginname = 'sa'
>You can obtain the package ID (@.id) from the
>msdb..sysdtspackages table (ID column).
>
>EXAMPLE:
>First get the id:
>Select id from dbo.sysdtspackages
>where name = 'MYDTSPACKAGE'
>GO
>Adjust the syntax
>Exec sp_reassign_dtspackageowner
>@.name = 'MYDTSPACKAGE',
>@.id = 'D72333A2-7DED-11D4-BF04-00B0D057DBE4',
>@.newloginname = 'Userid'
>
>Hope it helps......
>
>>--Original Message--
>>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.
>>Randa
>>.
>.
>|||In message <1f9501c3e103$6464b960$a301280a@.phx.gbl>, Randa
<anonymous@.discussions.microsoft.com> writes
>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