Run query on SSP database

This example is to show how SSP can run a query directly on the database using a command line action. From a form data is given into the process and within the process we execute a step of the type "Execute external application". We start a batch file and provide the query to be executed to the external application through a variable.

The content of the batch file is like this:

 
 @ECHO OFF
 echo %1 >> D:\Script\ExecutionLog.txt
 sqlcmd -U USERNAME -P PASSWORD -S SERVERNAME -Q %1 >D:\Script\result.txt
 ECHO ON
 @type D:\Script\result.txt