dbTalk Databases Forums  

DTS package fails intermittently while loading a large amount of d

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS package fails intermittently while loading a large amount of d in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dverma
 
Posts: n/a

Default DTS package fails intermittently while loading a large amount of d - 08-05-2005 , 12:19 PM






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)
----------------------------------------------------------------



--
Deepak Verma

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: DTS package fails intermittently while loading a large amount of d - 08-06-2005 , 04:30 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


"dverma" <dverma (AT) discussions (DOT) microsoft.com> wrote

Quote:
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)
----------------------------------------------------------------



--
Deepak Verma



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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.