You can create a linked server on SQL 2000 to SQL 7. After that you can us eINERT INTO...SELECT FROM to transfer data.

> I have 5 tables in sql server 7.0. Every night I need to copy the data from these five tables and import the data into the respected 5 tables in sql server 2000. I created a dts package to accomplish this, however the dta is not wroking properly. I was wondering if someone can show me an example of how to accomplish this using stored procedure, it would be a great help to me.