Post reply

Script Component Exec on target server

  • June 13, 2008 at 2:56 am

    #208299

    Hi

    Cross post from down south where it seems no mortals roam... 😀

    I have a script component in a dataflow that checks a variety of system config information.

    My issue of course is that it runs against my dev station - not against a target server... so my question is can I get it to run against a target server - or do I need to use a totally different approach (wmi etc)?

    Cheers

    Rich

  • June 13, 2008 at 4:19 am

    #828343

    If you have SSIS Configurations enabled it is simple, just change it there to run against the target server and TADA

    ~PD

  • June 13, 2008 at 11:18 am

    #828688

    Hi thanks for the reply... but could you expand on that?

  • June 16, 2008 at 2:59 am

    #829086

    Read up in BOL on SSIS Configurations.

    Basically, in your case, you need to set the configurations up for connections (I would assume its OLE DB or something).

    Now, whenever you need to change where it runs from, change the config and not the design.

    Trust this helps

    ~PD

  • June 16, 2008 at 4:14 am

    #829108

    Thanks - looks promising.

    Cheers

    Rich

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

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