DTS Package Owner

Leo Kozhushnik <an*******@devdex.com> wrote in message news:<3f*********************@news.frii.net>...

Hello there,

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

sp_changeobjectowner 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

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_reassign_dtspackageowner, 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_dtspackageowner.

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

Leo Kozhushnik <an*******@devdex.com> wrote in message news:<3f*********************@news.frii.net>...

Hello there,

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

sp_changeobjectowner 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!

Hi Leo, use the undocumented SP:
sp_reassign_dtspackageowner [@name =] 'name',
[@id =] 'id',
[@newloginname =] 'newloginname'
[@name =] 'name'
The package name.

[@id =] 'id'
This is the uniqueidentifier 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\Username'
Regards,
Thomas
http://www.sqlscripter.com