Transfering data with sql server integration services…
If we want to transfer data from one database table to another database we need to write complex code and queries. But with sql server 2005 integration services you can do it sometimes. You have to use sql server business intelligence studio(bundled with sql server 2005 developer edition). I have found a great article that