October 14, 2015 at 2:57 pm
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
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
BIDS 2008.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply