Results 1 to 3 of 3

Thread: DTS packet size

  1. #1
    Join Date
    Feb 2003
    Posts
    13

    Unanswered: DTS packet size

    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?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Default network packet size is 4096. How did you manage to make it 1?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Feb 2003
    Posts
    13
    Under the Data Link Connection tab the default packet size is 1. It gives you the option to Edit the value so I bumped it up to 2048.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •