In typical production scenarios, the database is not installed on the web server - but on a dedicated database server. In this case ther is no need for an SQL erver license on the web server.

Running an SSIS package on a server requires an SQL Server lincense on that server. So running SSIS packages on the web server will require an additional SQL Server license.

If the production environment contains a server with the right connectivity, and where an SQL Server license is already installed, it would be desirable to execute the SSIS packes on this server (the "remote server").

It is not directly possible excute an SSIS package on a remote server. Therefore, at custom web application callsed "Command Line Starter" has been developed for this purpose.

"Command Line Starter" (abbreviated CLS) is a web application, that is installed on the remote server, on which you need execute command line programs.

It has a REST interface with the follwing possibilities:

• Upload files (i.e. transmit files files from the caller's machine to the machine running CLS).

• Execute command line (return text written to standard output as a string).

This makes it possible to execute SSIS packages on remote server:

• Build a custom webform with the user interface you need.

• If you want to build a form that allows the end user to import data from an Excel spreadsheet, for example, the user interface should have a button to select and upload the file, and the form should save the uploaded file in the file system of the web server.

• (Optionally) call CLS to upload the SSIS package to the remote server - to make sure the SSIS package exists on the remote server - and is updated.

• In the example of importing an Excel spreadsheat, call CLS to (re)upload the spreadsheat file from the web server to the remote server.

• Construct a command line that runs DTEXEC with suitable parameters. In the above example with the Excel spreadsheet, the DTEXEC command line must refer to the uploaded file (the location on the remote machine!)

• Call CLS to execute the constructed command line. CLS will return any text written to standard output (e.g. SSIS progress and error information). Display this text in the custom webform.