Connecting to multiple OLE DB servers with a loop.
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.