Groups | Blog | Home
all groups > sql server dts > april 2006 >

sql server dts : cannot save DTS package


shank
4/29/2006 8:15:47 PM
I created a DTS package on a remote shared SQL server 2000.
It's been running without error over a month.
I made some simple edits. Package runs without error.
However, I cannot save the package. I get the below error.
For troubleshooting, I created a new package - saved it without any problem.
My original DTS has quite a few steps. Could this be an issue?
By chance is it taking too long to save and something is timing out?
Seems not likely...
Any thoughts?
thanks!
-----------------------------------------------
Error Source : Microsoft OLE DB Provider for SQL Server
Error Decsription : [DBNETLIB][ConnectionWrite (send()).]General network
error. Check your network documentation.

Allan Mitchell
4/30/2006 5:13:26 AM
Hello shank,

It certainly looks like a network problem. It looks as though maybe the
communication is getting dropped if it takes > a certain amount of time.
Are you seeing any errors from the network card or anything in the event
log? Can you save a file of similar size to the remote server?


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]

Randall Arnold
5/2/2006 11:15:05 AM
Have you tried saving the package to the local server that hosts the linked
server, instead? That solved similar problems for me.

Randall Arnold

[quoted text, click to view]

AddThis Social Bookmark Button