Legacy DTS Package on SQL 2005 - Give user rights to save

• Warren Peace

  SSCertifiable

  Points: 5871

  More actions

  October 4, 2007 at 5:05 pm

  #182494

  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

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  October 5, 2007 at 9:01 am

  #739563

  Hi Gene,

  What happens when developers try to save packages. If it's the same problem as described this this thread: http://qa.sqlservercentral.com/Forums/Topic405083-146-1.aspx#bm405192 , see Ed Vassies reply for a kb articles with a fix.

  Greg

  Greg

• Warren Peace

  SSCertifiable

  Points: 5871

  More actions

  October 5, 2007 at 9:38 am

  #739600

  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