Printed 2017/07/27 08:14AM

How do I .... grant access permissions for SSIS to users?

By Robert Davis, 2008/08/13

SSIS access permissions are managed via Component Services. It is the DCOM object named MSDTSServer. Here are the steps to follow. 
  1. Component Services -> Computers -> My Computer -> DCOM Config -> MSDTSServer
  2. Right click on MSDTSServer
  3. Click properties
  4. Click on the Security tab
  5. Select Customize and add the users/groups to the Launch/Activation and Access tabs accordingly
  6. Add the user to the local Distributed COM Users group
  7. Restart the SSIS service


Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.