ADD, REMOVE SSIS Package and run it.

• BoobyB

  SSCertifiable

  Points: 5470

  More actions

  May 27, 2011 at 7:53 am

  #236952

  Hello All,

  I need to give my developer on one of the dev server the right to able to ADD, REMOVE and RUN SSIS package permission.... how would I go about that.

  he doesn't even want to run it from SSMS (SQL AGENT) just connect to SSIS able to import new package , test it , run it or than delete it.

  Can any one help me here?

  Thanks in advance

• BoobyB

  SSCertifiable

  Points: 5470

  More actions

  May 27, 2011 at 9:25 am

  #1331065

  well i have found the answer of my own question, putting it here if some one else come across the same situatioon.

  give the windows user one of the three roles from MSDB database.

  db_ssisadmin

  db_ssisltduser

  db_ssisoperator

  With Regards,