SSIS Permissions - Access Denied

You would think these permissions would be handled within SQL Server or Management Studio, but that would be waaaay too easy.

To give someone access to SQL Server SSIS:

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 via services control panel

Taken from this article:
http://www.sqlservercentral.com/blogs/robert_davis/2008/08/13/How-do-I-grant-access-permissions-for-SSIS-to-users/

Find unused methods (including public) using Resharper 7

It took me a while to find a good post on this.   The following link shows how to use Resharper to find any used references.  I recommend also setting the Type or Type member is never used to an error to make finding unused code even easier.


http://chrisseroka.wordpress.com/2013/10/28/find-unused-private-and-public-methods-with-resharper/