I am trying to use a users input from the ‘Input Dialog’ activity to the insert the data from that input and add it to a column in my database called ‘Total’.
Database info:
Schema - Results
Table Name - RESULTS
Column Name - Total
I’ve tried looking on YouTube and on this forum as well as other forums but I haven’t managed to find a solution yet. I have also tried the Database activity with the ZIP file you can download however that was also no help.
You would then use query activity to send and insert query - in the parameters you would assign the total value as the variable called from the input dialog.
Something like ‘Insert Into Table_A (Total) VALUES (@Total)’ … etc