HI support - I would like to be able to set the connection string for a SQL task to the value contained in a visual cron variable.
I am pushing out updates to different servers depending on a parameter read in from a trigger table - I want to create one generic VC job that executes some SQL statements - I have a number of connection strings set up - one for each server - to do this I need to be able to have the connection string selected from a variable.

Thanks
Brett

Just wanted to see if this will be considered for an enhancement ?

You should already be able to do this now. You can just specify Connection string option when creating a Connection. Then just paste a Variable there (which you can change from other place).

---

Thanks for the tip - this does solve the problem - for anyone else's interest the connection string looks like this

Driver={SQL Server};Server=disql03;Database={USERVAR(metric_project)};Uid=username;Pwd=userpassword;

The connection will fail the test option in the connection dialog but does work correctly when used. 😁

Brett