Post reply

Script Task for looping to list of Oracle servers

  • April 28, 2011 at 12:26 pm

    #236623

    Hi !

    I Have list of oracle instances and i would like to run a query against all the Oracle database ,So i would like to use the Script task ,So can any one help in providing the code in looping to each Oracle databases in the connection string to run a query ?

    Thanks in advance 🙂

  • May 3, 2011 at 12:14 pm

    #1319303

    I have list of user names and passwords servers and databases in a table and is it possible to make a dynamic oracle connections with out any TNSnames.org file entry for all databases ? can some one provide me with an example ?

    Thanks in advance 🙂

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply