How to insert a row in a SQL table using Mail & Deploy
| FIRST CREATED ON 4 Aug 2026 I AUTHOR Emma Camacho |
With Mail & Deploy you can add rows to your SQL Table using the EXECUTE CODE action in a Task. In this example, we'll demonstrate how easy it is to do this.
Datasource definition
Task definition
EXECUTE CODE definition
and CODE
EvaluateSqlDatasourceExpression ("xxx.xxx.xxx.xxx\SQLEXPRESS", "insert into Status (id, status) values (4,1)", 0)
another example, this time, using dynamic expressions could be
EvaluateSqlDatasourceExpression ("xxx.xxx.xxx.xxx\SQLEXPRESS", "insert into Status (id, status) values (" & [TaskParameter].[id] & "," & [TaskParameter].[Status] &")", 0)
It is possible to run any queries as long as the user defined in the credentials' Datasource has permissions to run them.
For more information, see EvaluateSqlDatasourceExpression and Execute Code.
Looking for Additional Guidance?
If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.
Related Articles
How to create a Task using a PowerBI Supporting Report using SQL queries (with example)?
FIRST CREATED ON 13 October 2025 I AUTHOR Emma Camacho Following the example How to create a Word report using PowerBI as a data source in Mail & Deploy (with example)? we are ready to send the Reports to the Store Managers. The following screenshot ...How to create a Task using a PowerBI Supporting Report using DAX queries (with example)?
FIRST CREATED ON 23 October 2025 I AUTHOR Emma Camacho Following the example How to create a Word report using PowerBI as a data source in Mail & Deploy using DAX queries (with example)? we are ready to send the Reports to the Store Managers. The ...How to create a Task using a Qlik Supporting App (with example)?
FIRST CREATED ON 12 Mar 2026 I AUTHOR Emma Camacho Following the examples How to create a Sales Rep Analysis Word report in Mail & Deploy (with example)? and How to create a Body of Email (Word/HTML) report using Qlik as a datasource in Mail & Deploy ...How to manage a Send Email Test Run Using a Global Variable?
FIRST CREATED ON 14 Mar 2024 I AUTHOR Emma Camacho To ensure email tests are managed properly and avoid sending emails to unintended recipients, use a Global Variable to control test runs. This allows you to easily toggle between test and live modes. ...How to activate Delivery/Read receipts for Microsoft Outlook 365 E-Mail Server?
FIRST CREATED ON 5 Feb 2024 I AUTHOR Emma Camacho In order to activate Delivery and Read receipts for Microsoft Outlook 365 E-Mail Server add the following customer headers: "Disposition-Notification-To" "<email@company.com>" "Return-Receipt-To" ...