Newbie - Advice pls !

Hello

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 !:confused:yeah, i would say DTS is the way to go....just schedule the update every night...do 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