Networking Forums

Networking Forums > Computer Networking > Windows Networking > Connection from SQL Server 2005 to SQL Server 2000 stalling

Reply
Thread Tools Display Modes

Connection from SQL Server 2005 to SQL Server 2000 stalling

 
 
DaveF
Guest
Posts: n/a

 
      12-22-2006, 01:05 AM
We have an SSIS package running on a SQL Server 2005 machine. It is a
series tasks where it truncates a table on the 2005 machine and repopulates
the table by querying the equivalent table on our SQL Server 2000 machine.
The problem we are experinecing is that some of the tasks seem to stall and
the package, which should take about an hour and a half to run, instead runs
forever. We have determined however that it is not a SSIS problem because
we converted the SSIS package to a simple query job and that stalls also.
Now today, I tried to run a simple select from the 2005 machine on a table
on the 2000 machine and it just stalled after returning about 700 of the
4000 rows in the table.

Any of you SQL Server or Network wizards ever hear of this problem before?

Dave



 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows 2000 Server Acquring DHCP Addresses for a RAS connection James Windows Networking 3 03-22-2007 02:49 AM
as.net 2.0/sql server 2005 Hosting John Broadband 2 01-16-2006 09:04 PM
Desktop Connection to Terminal Server 2000 antonio Windows Networking 1 09-05-2004 11:29 PM
Trusts in 2000 level domain between 2000 server and 2003 server Brian@essential Windows Networking 0 08-18-2004 11:14 PM
Virtual server 2005 Mohamad Awada Broadband Hardware 0 06-24-2004 06:51 PM



1 2 3 4 5 6 7 8 9 10 11