This content has been marked as final. Show 2 replies
I am trying to run the same load script on multiple database servers without having several OLE connection strings with the same load statement copied / pasted. This of course makes changes to the load script difficult to manage. I would like to store the server names in a external file (excel?), and then execute the load using a server name variable in the connection string with a loop for each server name listed. To keep the results seperate for each server, I will store the results by appending the server name variable to the file qvd file name.
Any ideas on how to pull off the loop?
Thanks in advance.