Steps
Steps
- AWS S3 File Download
- AWS S3 File Upload
- Azure File Download
- Azure File Upload
- Create Directory
- Data Sync Project
- DataSync RunTool Project
- Delete Directory
- Email Message
- External Program
- File Copy
- File Delete
- For Each File
- Ftp File Download
- Ftp File Upload
- Http File Download
- Http File Upload
- Http Web Request
- Log Entry
- Ouvvi Database Backup
- Ouvvi Project
- Ouvvi Project Status Report
- Ouvvi Status Report
- Powershell
- Project Disable
- Project Synchronise Service
- Simego Change Service
- Slack Message
- SMS Message
- SQL Batch
- SQL Command
- SQL Database Backup
- SQL Job
- SQL SSIS DTEXEC Project
- SQL SSIS Project
- Start Windows Service
- Stop Windows Service
- Time Delay
- Teams Message
- Trigger Status Change
- Unzip a File
- Web API
- Zip a File
SQL Command
Executes a SQL statement against a SQL database.
| Parameter | Value |
|---|---|
| Connection Library | The name of the connection in the connection library. If this is selected then you do not need to complete the other fields. |
| Connection Provider | Type of Connection String (Optional: provided by Connection Library). |
| Connection String | Database Connection String (Optional: provided by Connection Library). |
| Connection Timeout | The time it will take for the connection to timeout. |
| SQL Command | The SQL command to be executed. |