Are you seeing this?
Package Ownership Issues
(http://www.sqldts.com/default.aspx?212)
"JLLDBA" <JLLDBA (AT) discussions (DOT) microsoft.com> wrote
Quote:
After I restore a msdb database from a server to another, I like to modify my
DTS
with my user MYUSER :
- I can create a new DTS,
- I can open and save a DTS with another name,
But
- I can't open and save a DTS with his original name
I don't like to change my user rights and adding this user in 'system
administors' server roles.
How can I change DTS owner or rights on DTS packages ? |