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
|