Scenario to test is Server A(SSIS not installed) remotely executing package on Server B(SSIS Server) via Batch file.
Case 1: Application is calling Batch file(on Server A) which in turn executes package on server BCase 2: Application is calling Batch file(on Server B) which executes package on server B
asked Oct 05, 2012 at 10:35 AM in Default
Any way you look at it, you'll need to execute the package on a machine with SSIS or BIDS installed. SSIS requires a SQL Server license. So your options are to either create an SQL Agent job on a SQL Server and have the job execute the package, or to create a Web Service on the machine with SSIS and have the Web Service start the package.
There's a Developer's guide in Books Online that shows both ways by example.
answered Oct 05, 2012 at 11:44 AM