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.
View Complete Post