 | |
Copying 2005 to 2000
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#41
 
| |||
| |||
|
Re: Copying 2005 to 2000 -
09-23-2008
, 03:17 PM
|
Ah, that worked thanks! I think I was trying to connect to the 2005 server from the 2000 enterprise manager. Thanks for the simple instructions. "Russell Fields" wrote: ngan, Just did it with no problem. Here is what I did. (Very simple and you may need more logic than I put in.) Created a new DTS Package on SQL Server 2000. Created a Connection object for SS2000. Created a Connection object for SS2005. Created a Transform Data Task, choosing SS2000 as the target. Ran package and data was copied. Are you running into rights issues? If you run the package interactively, it will run with your rights. If you schedule the package to run from the SQL Server, it will run with the SQL Server service's rights. Do you have more clues as to what went wrong? RLF "ngan" <ngan (AT) discussions (DOT) microsoft.com> wrote in message news:C02B9E3B-434F-424C-B9FE-5E8667377976 (AT) microsoft (DOT) com... I was unable to "pull" from 2005 to 2000 where the dts package originates from 2000. Am I missing something? I want a DTS package to originate from sql 2000 that connects to a sql 2005 server and copies a view (as a table) into 2000. "Russell Fields" wrote: ngan, Sure, you can pull data in to SQL Server 2000 from SQL Server 2005. You could do a DTS pull from 2005 or you could create a linked server and query through the link to get the data from the other server. (What you cannot do is restore a SQL Server 2005 database to SQL Server 2000.) If any datatypes are different between the servers, you will need to resolve those issues in your package or query, of course, but it should all be doable. RLF "ngan" <ngan (AT) discussions (DOT) microsoft.com> wrote in message news:458B6C8E-CB1A-453F-B6C9-168DA1534089 (AT) microsoft (DOT) com... I'm sure the answer is no because you can't look up, only down, but I want to make sure  I have a SQL 2000 server and a SQL 2005 server. I need to copy a 2005 view into the 2000 server (as a table). I was thinking of doing a DTS push, but it would be much better if the 2000 server can do a pull because the 2000 has to do other functions with that copy of the table. Is there a way for a 2000 server to copy data from a 2005 server? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.