Currently to execute stored SQL code you have to do a file read task of the code and then a second sql task reading the output of the previous job to execute. It would be nice if the sql task could have a browse path and credentials to get the code. this would also improve visibility of what was being executed. We are required to maintain sql code in managed folders and not internally on VC hence the request.

Brett.

Brett,
See if you can use the following read variable that I've attached a picture of.

That works perfectly thank Trevinom - still would be nice to have a dedicated browse box for the file 😁 but this will save having a separate step to read the file.

Thanks
Brett