sql server dts: how to change dts owner name -- sql server dts

RE: how to change dts owner name

John Cappelletti
9/30/2004 5:39:01 PM

sp_changeobjectowner

I've never had to change a dts owner, but this is where I would look first.

John

[quoted text, click to view]

Re: how to change dts owner name

Sue Hoegemeier
9/30/2004 7:52:53 PM

Using sp_changeobjectowner won't work. You can use the
undocumented sp_reassign_dtspackageowner. You can find
information on package ownership issues at:
http://www.sqldts.com/default.aspx?212

-Sue

On Thu, 30 Sep 2004 17:12:12 -0700, "JJ Wang"
[quoted text, click to view]

Re: how to change dts owner name

Dan Guzman
9/30/2004 8:02:14 PM

Check out http://www.sqldts.com/default.aspx?212.

--
Hope this helps.

Dan Guzman
SQL Server MVP

[quoted text, click to view]

Re: how to change dts owner name

Dan Guzman
9/30/2004 8:03:23 PM

sp_changeobjectowner is intended for SQL Server database objects and can't
be used for DTS packages.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"John Cappelletti" <JohnCappelletti@discussions.microsoft.com> wrote in
message news:7D4B53C1-5AAD-42F5-A8FE-C1DB9DB37508@microsoft.com...
[quoted text, click to view]

RE: how to change dts owner name

Umut Nazlica
10/1/2004 1:37:03 AM

I use:

use msdb
go
sp_reassign_dtspackageowner [@name =] 'name',
[@id =] 'id',
[@newloginname =] 'newloginname'

--to find dts package id :

use msdb
go
select * from sysdtspackages
go

[quoted text, click to view]

thank you so much, everyone!!

JJ Wang
10/1/2004 11:36:51 AM

wow, thanks to you all for the quick response, tons of
good tips here. you solved my problem!!

thank you so much!!!!

JJ
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.