SQL Server 2K with SP4

[mac2k]

Hi everyone!

I have 3 DTS on my SQL Server 2k running with SP3 and they worked fine scheduled in jobs. About 3 weeks the administrator installed SP4 and now I can not see the packages to modify them, can not run the packages. every time I want to run them or to see them I recieved the message "[DBNETLIB][ConnectionRead(recv()).]General Network error." I have checked the ODBC driver, reconfigure it, redo it and I get the same error.
I can make new packages, but when I save them and want to see them again I get the same error.

Anyone have any idea what is happening with my DTS now?

Thanks in advantage.

 

[mrdenny]

Have you installed SP4 on your workstation?

When the packages are run are they run as jobs? To they run successfully as jobs? From the server console?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[mac2k]

Thank you Denny, these DTS were running as JOBS in the server and they ran fine until the installation of the SP4, I haven´t install SP4 on my workstation, that's a good point.

I'll install it and see what happens.

Thanks again

 

[mrdenny]

What happens when you run the package manually from the servers console?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog