SSIS packages may be deployed to the file system and run using the DTEXEC utility from the command line.

This makes it possible to set up scheculed tasks to exeucte SSIS packages periodically - without user intervention.

Advantages:

• Perfect for periodic, asynchronous operations - useful in many interfaces / integration tasks.

• May be run on any server - it is not required to be neither the web server (where TOPICA is installed) nor the database server.

  An SQL Server license must be installed on the machine, though.

Disadvantages:

• No direct information returned to user. The packages must be designed to save information in logs, and reports must be developed to let end users inspect these logs.