change DTS owner

[rsbutterfly16]

hi guys! i am trying to change the owner of my dts but i keep getting an error:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'nameofDTS'.

this is what i am using:

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

 

[nice95gle]

[@name=],[@ID] and [@newloginname =] is just a twisted way of stating you can place a variable there, you need yo leave it out.

Use MSDB
GO
exec sp_reassign_dtspackageowner 'PackageName' , 'id' , 'new_owner'


Well Done is better than well said
- Ben Franklin

 

[rsbutterfly16]

thanks! worked like a charm! have a great day.