June 5, 2003 at 3:03 am
Could someone please tell me how I could change the ownership of a DTS package?
Also is there anything that I should be aware of when I do this?
TIA
Carl.
June 5, 2003 at 3:04 pm
Try the sp_reassign_dtspackageowner stored procedure in msdb. You must be the current package owner or a member of the sysadmin server role to run it. I haven't had any problems with it.
Greg
June 6, 2003 at 2:05 am
sp_reassign_dtspackageowner
Is that an undocumented SP?
June 9, 2003 at 12:02 pm
Yes, although it's fairly well commented inside the SP.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply