SQL Server Performance

Creare a DTS Package that runs on all the servers

Discussion in 'Getting Started' started by Arman, Nov 25, 2007.

  1. Arman New Member

    Hi All,
    I have a Backup Store Procedure (which will give me latest backup history in one server's Databases )which i want to run a on all the servers by creating a DTS Package. I dont know that how i can create such kinda package thats can run on all the SQL servers and put the output in a table or in a file.
    Any Help that what are the steps i should fallow to create suck package
    Thanks in Advance.................... [*]
  2. ranjitjain New Member

    You can create DTS package with dynamic SQL connection string i.e. you can change the SQL connection properties during execution and then retrive the result and store it in central repository.
    One option is to first store connection details of all servers in a table and then create activex script task which will fetch records from this table and execute step to fetch backup details using this connection string. After this store this detail in another table in same db. This you can loop for all servers.

Share This Page