Hi all,

Apologie this is a newbie question, but I cannot figure out (from documentation or my own testing) how to execute a SQL statement in a task and assign the result to a variable.

Is there a tutorial that highlights this ?


Thanks,
Ben

Hi Ben, welcome to the forum!

What you need to do is setting up a connection to your SQL server and making a user defined variable.
Use this connection in the database task to execute your SQL statement.
Then you need a set variable task to get the output of the database task en assign this to your variable.

Good luck,
Erik

---

Many thanks Erik!!