SSIS access permissions are managed via Component Service under DCOM Config
1. Run –> dcomcnfg.exe or Component Services -> Computers -> My Computer -> DCOM Config -> MSDTSServer
2.Right click on MSDTSServer or MSDTSServer100 ( based on SQL version )
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
How to add user in local Distributed COM Users group
- Right-click My Computer>Manage>Configuration>Local Users & Groups
- Look for the Distributed COM Users group and add the account.