HI support - Is there any way 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.
Possible ?
Thanks
Brett