Hi All,
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.

Thanks
MA