DTS packet size

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Wes (anonymous_at_discussions.microsoft.com)
Date: 10/08/04 

Date: Fri, 8 Oct 2004 10:52:17 -0700

I have a dts package that transfers data from a view into
a table structure on another server. Occassionly the
scheduled package will fail with the following error:

Error = -2147467259 (80004005) Error string:
[DBNETLIB][ConnectionRead (recv()).]General network error.
Check your network documentation. Error source:
Microsoft OLE DB Provider for SQL Server Help
file: Help context: 0 Error Detail
Records: Error: -2147467259 (80004005); Provider
Error: 11 (B) Error string: [DBNETLIB]
[ConnectionRead (recv()).]General network error. Check
your network documentation. Error source: Microsoft
OLE DB Provider for SQL Server Help file: Help
context: 0 DTSRun OnFinish: Copy Data from PS...
Process Exit Code 1. The step failed.

Once the package fails I will rerun it several times
without any modifications and eventually it will run to
completion successfully. One change that I have made while
troubleshooting is to change the default network package
size from 1 to 1024 or 2048. Although this has worked I'm
not confident that the package wouldn't have run without
that change.

Has anyone seen this error before or anything similar?

Relevant Pages

  • strnsl 0.9.2.3 Released - Network Services Library for Linux Fast-STREAMS
    ... Package strnsl-0.9.2.3 was released under GPLv2 2007-06-24. ... UNIX has traditionally provided three components of the Network ... The OpenSS7 STREAMS Network Services Library package contains header ... Support build on openSUSE 10.2. ...
    (comp.os.linux.announce)
  • 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)
  • Re: Use of Advanced Client Network Access Account
    ... >>From what I've seen SMS will only failover and try the ... >account if it first gets an access error to the package ... network ressources outsite the SMS-Site (a share on any ... >decide if the network access account can be used. ...
    (microsoft.public.sms.swdist)
  • RE: SSIS null password given when executing package
    ... It would fail if you are logging onto the server with an account that is ... ProtectionLevel property of the package may be set to ... Charles Kangai, MCT, MCDBA ... The thing that throws me is why does the package fail if it is executed on ...
    (microsoft.public.sqlserver.dts)
  • Re: Use of Advanced Client Network Access Account
    ... can you explain to me how SMS knows when or if a package ... SMS allows Packages which don't need a distribution point ... seems not to be regarded as a network access. ... >>I defined Advanced Client Network Access Account on the ...
    (microsoft.public.sms.swdist)