Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Nottingham - UK

    Unanswered: Newbie - Advice pls !


    I am running a HR database on a 2K SQL 2000 box which administrators have no access to in the near future - I am needing to export certain data from the db to another 2K SQL 2000 box for use in the company phonelist etc.

    I am looking at running the task say at midnight every night, the query will replace the data on the destination server.

    I know this sounds very vague - is DTS the correct medium for the job ?

    Can anyone point me in the right direction on this ?

    Thanks in advance !

  2. #2
    Join Date
    Jul 2003
    yeah, i would say DTS is the way to go.....just schedule the update every you want to overwrite the data on the destination server or simply append to it? If you want to append an leave the existing data there dont forget, use insert rather than update.

    Hope this help
    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts