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

• venkyzrocks

  SSCommitted

  Points: 1907

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  October 14, 2015 at 10:11 pm

  #1833363

  What version of SSIS are you using?

  ---

• venkyzrocks

  SSCommitted

  Points: 1907

  More actions

  October 15, 2015 at 2:23 pm

  #1833616

  BIDS 2008.