SQL Server Performance

Execution of DTS failed.

Discussion in 'SQL Server DTS-Related Questions' started by indshri, Mar 7, 2006.

  1. indshri Member

    Using a vendor application we are running a process called as Flowchart run ( this is run from the application.). Vendor appln installation folder has this log file from which I am sending the error. <br /><br />I am running this appln on a 4 CPU ( no hyper threading ), with 15.8 GB RAM , SQL Server has been allocated 14 GB using max server memory setting, AWE is turned ( No PAE switch ), OS is Windows Server 2003 SP1...<br /><br /><br />Below is the detailed error ----- Any ideas ...<br /><br />The execution of the following DTS Package failed: <br />Error Source: Microsoft Data Transformation Services (DTS) Package <br />Error Description:The task reported failure on execution. <br />Error code: 8004043B <br />Error Help File<img src='/community/emoticons/emotion-7.gif' alt=':s' />qldts80.hlp <br />Error Help Context ID:700 <br />Package Name: c:catalysttechqsi9Tempi132014__75aaec99-4418-4e25-aa86-cdc8bd19f8d6.tmp <br />Package Description: (null) <br />Package ID: {C9E634BB-B328-4062-9F60-81F3DD73EE3D} <br />Package Version: {D174A3DD-6813-44BF-B8C9-DEC0BDEDB45F} <br />Package Execution Lineage: {AF779B5A-104D-4136-AED3-72467C36F561} <br />Executed On: MSWAUMDST01 <br />Executed By: i132014 <br />Execution Started: 3/5/2006 3:33:05 PM <br />Execution Completed: 3/5/2006 4:12:51 PM <br />Total Execution Time: 2386.594 seconds <br />Package Steps execution information: <br />Step 'copy step' failed <br />Step Error Source: Microsoft Data Transformation Services (DTS) Package <br /><b>Step Error Description:The task reported failure on execution. (Microsoft OLE DB Provider for SQL Server (80004005): [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.)</b>Step Error code: 8004043B <br />Step Error Help File<img src='/community/emoticons/emotion-7.gif' alt=':s' />qldts80.hlp <br />Step Error Help Context ID:700 <br />Step Execution Started: 3/5/2006 3:33:05 PM <br />Step Execution Completed: 3/5/2006 4:12:51 PM <br />Total Step Execution Time: 2386.594 seconds <br />Progress count in Step: 214340
  2. satya Moderator

    Ensure SQLAgent has required privileges to carryupon the further tasks as per the DTS package, ensure database transaction log and TEMPDB are not in contention when trying to complete the process. Setup a trace to see underline events during the process.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page