I am working on creating a CLR that can return the list of running SSIS packages on a given server, managed to implement everything, compiled, deployed successfully, ran without errors.... but not results returned, although clearly packages are running on that server (could see then in Integration Services).
Moreover when I change the servername to a nonexisting server I get the errors, and if I use the same c# code outside the CLR I get the correct results.
Not sure what to try next, feels like a security/permissions issue...
Used Application.GetRunningPackages method, SQL 2008R2 Developer edition, .Net 2.0
Thanks in advance for your help/feedback.