Re: DTS packet size

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 10/09/04 

Date: Sat, 9 Oct 2004 11:23:42 +0100

This error 80004005 is generally a security error through either your
credentials being supplied or the resource you are trying to reach is
unavailable/tied up/having problems.

Have you tried creating an alias in cliconfg?

I generally create TCP IP aliases for my SQL Server through this utility. 

-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Wes" <anonymous@discussions.microsoft.com> wrote in message 
news:0a6b01c4ad5f$8d1887f0$a501280a@phx.gbl...
>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

  • 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 package fails intermittently while loading a large amount of d
    ... 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 ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduling DTS job
    ... Does the job involve the network? ... Does the package involve SQL Server? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > Recently my scheduled DTS job slowed down drastically. ...
    (microsoft.public.sqlserver.dts)