Read SQL Value into Automise Variable

Automise Discussion
1

HI,

     Fairly new to Automise2, I was wondering if it is possible to read a value from an MSSQL database table column using the MSSQL functions, and then place the value into an Automise variable.

Brian(UK)

 

2

Hi Brian,

Yes, this is possible, but might require a little bit of work to get it going exactly the way you need.

If you use the MSSQL Execute SQL action, then you can output the result to a text file. You can then read this in (using Read Text File) to a variable, which then may or may not need some manipulation to get the right value.

If you use the ADO Execute SQL action, then this can output to xml which might be a better way to go. You can then use the Read XML Value to Variable to extract the right bit of data.

hth.

3

Thanks Tate,

                         I went the XML way, works a treat.

Brian