July 27, 2007 at 8:40 am
Hi, I have an operational system running on SQL2005.
The data warehouse, reporting server and anaylsis services all run on SQL2000 on separate tin.
I want to copy data from the 2005 database into the 2000 database periodically (daily, weekly, monthly).
I have successfully linked the 2000 database to the 2005 server but have been unable to link the 2005 server to the 2000 server. Any ideas what I could try to achieve this?
I have also tried using the SQL connection within a DTS package to connect to the 2005 data source, but that comes up with a "SQL Server does not exist or access denied" error message.
Any ideas please?
Thanks,
Duncan
July 31, 2007 at 8:58 am
I'm not sure how much help I can be. I'm able to create a connection in a DTS package for a SQL 2005 data source. The only time I've gotten the "SQL Server does not exist..." message is when I spelled the server name wrong. This kb article talks about possible causes: http://support.microsoft.com/kb/328306/en-us
I don't know what you mean when you say you've linked the SQL 2000 database to the SQL 2005 server but can't link the SQL 2005 server to the SQL 2000 server.
Greg
Greg
July 31, 2007 at 7:18 pm
I don't think you can use linkserver from 2005 to 2000. You either have to use SSIS in SQL 2005 or DTS in SQL 2000 to get data back and forth.
July 31, 2007 at 7:20 pm
I used DTS package in SQL 2000 server connecting to SQL 2005 server and put data in the SQL 2005 box. I have to create a ODBC connection for SQL 2005 server.
August 2, 2007 at 2:42 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply