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 B
Case 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.
You didn't mention your SQL Server version, but the article above comes in versions for each SQL Server version from 2005 and up, just select your SQL Server version from the "Other Versions" dropdown on top of the page.
answered Oct 05, 2012 at 11:44 AM