Re: DTS Problem General Network error

Thank you for your help,

but your suggestion don't help me.

My Problem is, when the task was scheduled, it start but after a few
minutes the task end with 'General network error'.

I've test the follow suggestion but it doesn't help

http://support.microsoft.com/default.aspx?scid=kb;EN-US;899599

gollo007


Charles Kangai schrieb:

It could be a security issue. That is usually the main reason why a job that
runs successfully interactively then fails to run when scheduled. Try using
the Run As feature to get round this. To do this, see the following Books
Online topic:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/69d3958c-6abc-41ae-8428-312917867c9a.htm

Hope this helps.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk


"gollo007" wrote:

Hi,

we are using SISS package (no DTS package sorry). In the task we have a
SQL that update columns. If I start the task manually, the task run 45
minutes.

Thanks, gollo007



Charles Kangai schrieb:

Please give more details: You are running 2005, so is this an SSIS package
rather than a DTS package? Are you running a DTS package from SSIS? What is
the Execute SQL Task doing?

Hope this helps.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk


"gollo007" wrote:

Hi Everybody,

I am having problems in DTS packages that runs nightly. It is
always the same Error at the same 'Execute SQL Task'. The ohter Tasks
in
the same DTS packages works fine with the same OLE connection.

"[DBNETLIB][ConnectionRead (recv()).]General network error.
Check your network documentation.".
Possible failure reasons: Problems with the query, "ResultSet" property
not set correctly, parameters not set correctly, or connection not
established correctly."

But if I execute the task manually, it works.

We have SQL server 2005 on WK2003

Any help will be appreciated.
Thanks, gollo007





.

Relevant Pages

  • Re: DTS Problem General Network error
    ... Charles Kangai schrieb: ... Author of Learning Tree's 4-day course: "SQL Server 2005 Integration ... email alias: charles ... we are using SISS package (no DTS package sorry). ...
    (microsoft.public.sqlserver.dts)
  • Re: How to capture SQL statement messages in DTS log file
    ... I have several SQL Server 2000s and a couple of SQL Server 2005 servers ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)
  • Re: export access to sql server
    ... i followed article from sql server books MSDN. ... Running a DTS Package Saved as a Visual Basic File ... Actually my software will support access ... If the app needs to dynamically recreate the ...
    (microsoft.public.vb.general.discussion)
  • Executing a DTS package from a Web application.
    ... Can a SQL Server 2000 DTS Package be run from a Web application? ... The SQL Server database is not local. ... Package Execution Lineage: ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Problem General Network error
    ... Charles Kangai, MCT, MCDBA ... email alias: charles ... we are using SISS package (no DTS package sorry). ... always the same Error at the same 'Execute SQL Task'. ...
    (microsoft.public.sqlserver.dts)
Loading