Click here to Skip to main content
13,089,610 members (56,032 online)
Rate this:
Please Sign up or sign in to vote.
See more:

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.
Posted 20-Nov-12 16:19pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Follow the steps below:

1.Use SQL server Export Import wizard. There you will have facility to connect different server with different userid, password.
2.At the last window of the package you will have a provision to save your works as a SSIS package(DTS is no longer available from SQL 2005).
3.Schedule the the SSIS package to execute monthly basis using SQL Agent Job.

Hope it will helpful.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.170813.1 | Last Updated 21 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100