Friday, March 23, 2012

How to change dts owner

It is possible to change dts owner ?
If it is possible, How to change the owner.
thanks.>--Original Message--
>It is possible to change dts owner ?
>If it is possible, How to change the owner.
>thanks.
>.
>
Try this:
http://www.sqldts.com/default.aspx?6,105,212,0,0
Regards,
Thomas
http://wwwl.sqlscripter.com|||Try this:
sp_reassign_dtspackageowner [@.name =] 'name',
[@.id =] 'id',
[@.newloginname =] 'newloginname'
Both the @.name and @.id parameters are required as a package name is not
guaranteed to be unique.
Zvi
"kresna rudy kurniawan" <kresnark@.yahoo.com> wrote in message
news:25e5f01c38e11$886a4540$a601280a@.phx.gbl...
> It is possible to change dts owner ?
> If it is possible, How to change the owner.
> thanks.|||Hello
> It is possible to change dts owner ?
> If it is possible, How to change the owner.
Update msdb..sysdtspackages set owner = 'newowner' where versionid ='...'
Serge Shakhovsql

No comments:

Post a Comment