I am using SQL server 2008. I have a requirement to transfer data from a one database to another database tables which are in the same server. But the login credentials for each of the database is different. This task need to be done monthly basis. Which is the best approach? SQL job or DTS package? Please suggest any good article for this problem.