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.

Hi Yousaf, If you would like to know that is possible or not; it is totally possible. If you want to know "how", please specify on what topics you exactly want to know "how". But in general: You get relevant data from SQL 2008 to SQL 2008 (Stage), you do your Transformations (if needed) and finally you transfer data to Target server from Stage Server. Most of the time, you may even dont need a stage table so please consider if you really need temp tables. Regards Onur BI and ERP Senior Consultant @ Nexum Bogazici If it is, Please dont forget to mark as answered or at least vote as helpful if the post helps you in any ways.

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...