How to insert a row in a Microsoft SQL Server table within a Mail & Deploy Task?

How to insert a row in a Microsoft SQL Server table within a Mail & Deploy Task?

FIRST CREATED ON 19 Dec 2024  I  AUTHOR Emma Camacho

If a new row should be added to a table in a Microsoft SQL Server Database when running a Mail & Deploy Task, this can be achieve following the steps described below.

Create a Microsoft SQL Server Datasource




and then use this Expression in the Action Execute Code:
EvaluateDatasourceExpression("datasource_name", "query" )


 
The challenge is to make your SQL Server reachable to the M&D instance and then set all the permissions to allow to insert a row in a table.


Info
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.