permission needed to work with packages?

• ericb1

  SSCrazy

  Points: 2354

  More actions

  December 1, 2008 at 3:53 pm

  #196754

  I have a sql user who wants to be able to save and run DTS packages (or SSIS packages) in my SQL Server 2005 instance.

  What are the minimum amount of permissions I need to grant to this user to do this? I don't really want them to be sysadmins.

  Any help is greatly appreciated, thanks!

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  December 1, 2008 at 4:29 pm

  #905977

  Eric, have a look at new roles available for managing dts:

  http://technet.microsoft.com/en-us/library/ms141053(SQL.90).aspx

  HTH,

  MJ