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 descries all the thing that how you can create a package with sql server 2005 and how you can excute this package with sql server 2005 business intelligence studio.
here is the link for that cool article..