October 4, 2007 at 5:05 pm
We have a SQL server with many legacy DTS packages. sa and Admins can open them and change them then save them but we need to allow the DTS people (Developers) the rights to save the package after they have opened it and modified it.
Thanks
Gene Laoyan
October 5, 2007 at 9:01 am
Hi Gene,
What happens when developers try to save packages. If it's the same problem as described this this thread: http://www.sqlservercentral.com/Forums/Topic405083-146-1.aspx#bm405192 , see Ed Vassies reply for a kb articles with a fix.
Greg
Greg
October 5, 2007 at 9:38 am
The link you gave has a different issue. Tmessage we get is...
Error Description : Only the owner of the DTS Package 'PACKAGE_NAME' or a mamber of the sysadmin role may create new versions of it.
Is there a way to give the developer rights to save? They can open it and modify it but the get the above error when they try to save it.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply