I need to pick from a list of servers to deploy to, referenced by name and int ID. How can I load this list into a dropdown or checklist for picking and iteration of the selections?
My suggestion would be to use an ADO Dataset Iterator and then a Prompt for Variables (enhanced). Any other suggestions?
I’ve done this a few times.
1) Use the iterator to populate a variable like %servers% with a value separated by newlines: "SERVERCODE1 - Description of server1[NL]SERVERCODE2 - Description of server2…[NL]"
2) Use a “check list” type field with %servers% as the “Values” field.
3) Iterate through the resulting variable, trimming the select result from something like “SERVERCODE1 - Description of server1” to just “SERVERCODE1”.
Steve
EDIT: forum software strips out anything resembling an HTML tag. And it does it badly