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

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5A06027B-A863-408F-89B4-4E562BA32B56@xxxxxxxxxxxxxxxx
>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


.

Relevant Pages

  • Re: DTS Security
    ... But we still need to create a login into the SQL Server, ... the DTS package. ... For information about the Microsoft Strategic Technology ... > Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • Re: False string truncation error
    ... String or binary data would be truncated. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... Microsoft Data Transformation Services> Package ...
    (microsoft.public.sqlserver.dts)
  • Re: Trying to get a SSIS Import wizard package to actually schedule and work.
    ... Microsoft Global Technical Support Center ... |> would like to explain that we are allowed to re-use the SSIS package ... We use this task to transfer the SQL Server ... |> Objects Task" for your reference. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS packet size
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... >I have a dts package that transfers data from a view into> a table structure on another server. ... > Check your network documentation. ...
    (microsoft.public.sqlserver.dts)
  • Microsoft OLE DB Provider for SQL Server (0x80004005)
    ... General network error. ... This error is being generated from an ASP page to a SQL Server 2000 ... Microsoft says it might be a connection pooling issue. ... this is the only stored procedure that generates this error. ...
    (microsoft.public.data.oledb)