DTS Package Owner

[Leo Kozhushnik]

Hello there,

Im trying to change the owership of the DTS package but am a little
confused.

sp_changeobject owner changes the ownership of table, view, or stored
procedure in the current database...

How could i change the DTS package ownership?

Thank you in advance.

Leo



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Simon Hayes]

Re: DTS Package Owner

Leo Kozhushnik <anonymous@devd ex.com> wrote in message news:<3f1390c1$ 0$202$75868355@ news.frii.net>. ..[color=blue]
> Hello there,
>
> Im trying to change the owership of the DTS package but am a little
> confused.
>
> sp_changeobject owner changes the ownership of table, view, or stored
> procedure in the current database...
>
> How could i change the DTS package ownership?
>
> Thank you in advance.
>
> Leo
>[/color]

In most cases, it doesn't really matter who owns the package - who is
executing it is more important. However, there is an undocumented
stored procedure called msdb..sp_reassi gn_dtspackageow ner, which you
can use.

You might want to look at http://www.sqldts.com - in the
Administration and Management section of the FAQ, there is an article
on package ownership issues, including a wrapper procedure for
sp_reassign_dts packageowner.

Of course, since this procedure is undocumented, you should be careful
using it, and preferably never in production code - its behaviour may
change in future releases with no warning.

Simon

[Thomas]

Re: DTS Package Owner

Leo Kozhushnik <anonymous@devd ex.com> wrote in message news:<3f1390c1$ 0$202$75868355@ news.frii.net>. ..[color=blue]
> Hello there,
>
> Im trying to change the owership of the DTS package but am a little
> confused.
>
> sp_changeobject owner changes the ownership of table, view, or stored
> procedure in the current database...
>
> How could i change the DTS package ownership?
>
> Thank you in advance.
>
> Leo
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]



Hi Leo, use the undocumented SP:


sp_reassign_dts packageowner [@name =] 'name',
[@id =] 'id',
[@newloginname =] 'newloginname'


[@name =] 'name'
The package name.

[@id =] 'id'
This is the uniqueidentifie r for the package. A name may not
necessarily be unique.

[@newloginname =] 'newloginname'
The new Owner name. SQL Server login example 'sa', NT Integrated
example 'Domain\Usernam e'


Regards,
Thomas

http://www.sqlscripter.com