sql server dts: DTS package fails intermittently while loading a large amount of d -- sql server dts

DTS package fails intermittently while loading a large amount of d

dverma
8/5/2005 9:19:05 AM

sql server dts:

I am loading a large amount of data in sql server from a text file, some time
the package fails with follwong information written in exception file

Error at Destination for Row number 32376. Errors encountered so far in this
task: 1.
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description:[DBNETLIB][ConnectionWrite (send()).]General network
error. Check your network documentation.

While this error does not happen at all the time I am unable to find what's
causing the issue. SQL 2000 is installed on windows 2000 server version
5.00.2195 service pack 3
--------------------------------------------------------------
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
----------------------------------------------------------------

--

Re: DTS package fails intermittently while loading a large amount of d

Allan Mitchell
8/6/2005 9:30:01 AM

To me then because it works sometimes and others not and because the error
mentions that there is a network error I would suspect that the box on which
the package is running loses communication with one of the connections in
the package.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

[quoted text, click to view]