January 22, 2008 at 1:12 pm
I have two systems running. One database is in SQL 2000 and the other in SQL 2005. Some data which is entered in SQL 2000 has to be extracted and should be inserted into SQL 2005 database. Since I have limited access to the database in SQL 2005, my superior has asked to write a DTS package in SQL 2000. How can I connect to SQL 2005 database from SQL 2000? If anyone has done this type of data extraction kindly help me in accomplishing this task.
Thanks
January 22, 2008 at 1:34 pm
There's really nothing tricky to it: you simply create a package, which has a source DB object connected to the 2005 server and a destination object pointing to the 2000 server. Once you do that - then define one or more transformations between the 2 to import data from one to the other.
The version thing should make no difference - DTS will treat the 2005 server pretty much just like any other remote SQL 2000 server.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply