Post reply

Remotely executing a SSIS package through excel, batch etc...

  • October 14, 2015 at 2:57 pm

    #305509

    Hey Guys

    I have built a SSIS package that I can call through batch file on the server. The SSIS package runs a view and aggregates data, based on the date filter.

    Q1: I need to be able to remotely execute this SSIS package through excel, batch file or any other thing that works. We do have a reporting tool, but these are non-regular users and we will be wasting licenses if we start handing out reporting to each and every user.

    Q2: How can I remotely pass parameters through this program to run the SSIS package.

    Any help is appreciated here. I need to hand this over and let users run at their own convenience after entering date fields.

    Danke,

    V

  • October 14, 2015 at 10:11 pm

    #1833363

    What version of SSIS are you using?

    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

  • October 15, 2015 at 2:23 pm

    #1833616

    BIDS 2008.

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

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