May 14, 2003 at 2:49 pm
I have created a bunch of packages for developers ( to copy prod data to their individual databases). I would like them to maintain the changed to this package( adding new tables to be copied etc). However DTS will not allow them to save the changes since i am the owner. How do i transfer ownership or let them edit and change packages ? Is there a DTS equivalent of sp_changeobjectowner ?
tia
-srini
May 14, 2003 at 3:21 pm
found the answer on http://www.sqldts.com
May 14, 2003 at 3:23 pm
http://www.sqlservercentral.com/scripts/contributions/450.asp
"Change DTS package owner"
This link may help you to change the dts package owner.
May 16, 2003 at 9:01 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply