Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

CLR function not returning results for GetRunningPackages Expand / Collapse
Author
Message
Posted Thursday, June 13, 2013 8:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 06, 2013 5:38 AM
Points: 1, Visits: 61
Hi there,

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.
-A
Post #1463106
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse