Data extraction through ssis in client server concept
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.
October 24th, 2010 8:52pm

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...
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 5:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics