Move selected data from one server to another sql server 2008

Question

I need to move selected data from 800+ tables in one database to the same 800+ tables in another database in another server. The data I select is based on date fields of every table. So, if I say table 1 date from 01/01/10 to 01/15/10, then only that data I want to be copied into the other server's database table specified. I hope I am not confusing anyone. What is easiest way to do this?

Answer 1

Look into SSIS. What you're talking about is very easy using it. Here is a page that talks about using variables in SSIS.