i am working on a data warehousing project for health care.i want to work on an architecture like this and need help... 1. source system is on another machine in sql server 2000. 2. data staging area database in sql server 2008 is used for temporary data stay on another machine. 3. target data warehouse in sql server 2008 is on third machine. How to import data through ssis from a data table in sql server from machine and put it into sql server or any other RDBMS on another machine.

The data warehouse tables in sql server 2008 will be on server machine and transactional tables will be on client side.I specially want to know how to do it through sql server integration services.please help,and staging tables are important for data cleaning purposes...