Inaccessible logs: Security

We are using Event Log quite a lot to log error messages from SSIS Packages, and sometimes there could be security issues when doing it.

One of the issues I encountered was the error

"The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security"

In French: "Erreur : la source est introuvable mais certains ou l'ensemble des journaux des événements n'ont pas pu faire l'objet d'une recherche.

Journaux inaccessibles : sécurité"

when logging with a custom Source in the Event Log

This error is happening because in order to use this Source, system has to access Security log, and the user that is running the SSIS Package has insufficient rights to access this log.

To add the user, go to regedit (Registry Editor), HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\eventlog

add a user that is running the SSIS Package (in my case it was NT AUTHORITY\Network Service) to Permissions (right click on key, then select "Permissions…") with Full Control to both eventlog and security keys

Passing Variable Values from Parent Package to Child SSIS - link

A simple and easy to follow article with pictures on how to pass parameters from parent SSIS package to a child SSIS package.

http://www.bidn.com/blogs/MikeDavis/ssis/155/passing-variable-values-from-parent-package-to-child-ssis

C#.Net Unit Tests - how to access intenal attributes and methods?

I was testing my code and found that I need to be able to modify some internal attributes and to test internal methods in my Unit Tests.

Fortunately there is a way to this!

It is very well documented in the links below:

http://msdn.microsoft.com/en-us/library/system.runtime.compilerservices.internalsvisibletoattribute.aspx

http://devlicio.us/blogs/derik_whittaker/archive/2007/04/09/internalsvisibleto-testing-internal-methods-in-net-2-0.aspx

Just a note: make sure you use internal, and not private access modifiers, and also, if your assembly name and namespace are different - make sure use Assembly Name in

[assembly: InternalsVisibleTo("XXXTests")]

You can find the Assembly Name in the project properties, Application tab.