Post reply

SSIS and Script Component

  • March 8, 2017 at 4:00 am

    #319520

    Does anyone know how to read from the event viewer logs of the server with a script component that is inside a foreach loop 

    I cant seem to get the code working on the loop through different servers 
    What is the syntax on C#

    EventLog myEvenLog = new EventLog("System", this.Connections.ServersLoop.ConnectionString);

    serversloop is the connection manager my connection that is theone that is used for the loop 

    Any help will be much appreciated

  • March 8, 2017 at 4:03 am

    #1932247

    in SSIS of course

  • March 8, 2017 at 5:02 am

    #1932253

    Do you intend to do this in a data flow, or did you mean script task?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 9, 2017 at 8:17 am

    #1932519

    I passed it as a Read only variable and it worked thank you for your reply

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply