Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
Hi,
 
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
good
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.
  Permalink  
v2

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

  Print Answers RSS
0 OriginalGriff 344
1 Sergey Alexandrovich Kryukov 337
2 CPallini 180
3 Abdul Samad KP 145
4 Richard MacCutchan 110
0 OriginalGriff 6,329
1 Sergey Alexandrovich Kryukov 5,700
2 CPallini 4,940
3 George Jonsson 3,469
4 Gihan Liyanage 2,522


Advertise | Privacy | Mobile
Web03 | 2.8.140916.1 | Last Updated 21 Feb 2013
Copyright © CodeProject, 1999-2014
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