Showing posts with label newname. Show all posts
Showing posts with label newname. Show all posts

Sunday, February 12, 2012

Change Owner Dts Package

Hi, i want to change owner to my dts package.
Can i do this problem to this procedure?
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
update sysdtspackages set owner = 'newname'
where owner ='oldname'
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Because in this case i update all old name.
I also test sp_reassign_dtspackageowner but i don't know how this comand to do on the table?

Thanks

Don't bother is my advice, it is not permanent and largely cosmetic.

Package Ownership Issues
(http://www.sqldts.com/default.aspx?212)