2 Replies Latest reply: Aug 15, 2013 1:27 PM by Marshall Malpass RSS

    Connecting to multiple OLE DB servers with a loop.

      Hello all,

       

      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.