Package Fails But Step Succeeds | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Package Fails But Step Succeeds

Hi,<br /><br />We have a package that reports failure but the step itself considers itself to have succeeded. The package is executed from an application server from VB code – no error info is returned. As you can see the package generates a general fail error but the step itself (‘DTSStep_DTSDataPumpTask_1′) sdays it has succeeded. (Package runs with 4 tasks in parallel).<br /><br />Any Ideas?<br /><br />Cheers,<br /><br />SteveH…<br /><br />The execution of the following DTS Package failed: <br /><br />Error Source: Microsoft Data Transformation Services (DTS) Package<br />Error Description<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />ackage failed because Step ‘DTSStep_DTSDataPumpTask_1′ failed.<br />Error code: 80040428<br />Error Help File<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />qldts80.hlp<br />Error Help Context ID:700<br /><br /><br />Package Name: USD User Data Extract<br />Package Description: USD User Data v3 Apptmts & Event Triggers<br />Package ID: {671D379D-5B7A-401A-81C4-B4558B0DC1C3}<br />Package Version: {1560AAFB-8114-48D0-896D-E285EB4520E1}<br />Package Execution Lineage: {1839E967-2762-4B83-897D-0EC40D0FA600}<br />Executed On: APP165<br />Executed By: 60353<br />Execution Started: 23/09/2004 11:16:35<br />Execution Completed: 23/09/2004 11:16:36<br />Total Execution Time: 1.11 seconds<br /><br />Package Steps execution information:<br /><br /><br />Step ‘DTSStep_DTSDynamicPropertiesTask_1’ succeeded<br />Step Execution Started: 23/09/2004 11:16:35<br />Step Execution Completed: 23/09/2004 11:16:35<br />Total Step Execution Time: 0 seconds<br />Progress count in Step: 0<br /><br />Step ‘DTSStep_DTSActiveScriptTask_1’ succeeded<br />Step Execution Started: 23/09/2004 11:16:35<br />Step Execution Completed: 23/09/2004 11:16:35<br />Total Step Execution Time: 0.016 seconds<br />Progress count in Step: 0<br /><br />Step ‘DTSStep_DTSExecuteSQLTask_1’ succeeded<br />Step Execution Started: 23/09/2004 11:16:35<br />Step Execution Completed: 23/09/2004 11:16:35<br />Total Step Execution Time: 0.016 seconds<br />Progress count in Step: 0<br /><br />Step ‘DTSStep_DTSDataPumpTask_1’ succeeded<br />Step Execution Started: 23/09/2004 11:16:35<br />Step Execution Completed: 23/09/2004 11:16:35<br />Total Step Execution Time: 0.047 seconds<br />Progress count in Step: 0<br /><br />Step ‘DTSStep_DTSDataPumpTask_2’ succeeded<br />Step Execution Started: 23/09/2004 11:16:35<br />Step Execution Completed: 23/09/2004 11:16:36<br />Total Step Execution Time: 1.062 seconds<br />Progress count in Step: 0<br /><br />Step ‘DTSStep_DTSDataPumpTask_3’ succeeded<br />Step Execution Started: 23/09/2004 11:16:35<br />Step Execution Completed: 23/09/2004 11:16:35<br />Total Step Execution Time: 0.031 seconds<br />Progress count in Step: 0<br /><br />Step ‘DTSStep_DTSDataPumpTask_4’ succeeded<br />Step Execution Started: 23/09/2004 11:16:35<br />Step Execution Completed: 23/09/2004 11:16:36<br />Total Step Execution Time: 1.047 seconds<br />Progress count in Step: 0<br /><br />Step ‘DTSStep_DTSDataPumpTask_5’ was not executed<br /><br />Step ‘DTSStep_DTSDataPumpTask_6’ was not executed<br /><br />Step ‘DTSStep_DTSDataPumpTask_7’ was not executed<br />****************************************************************************************************<br /><br />
What SQL Server and SP do you have?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
On the data pump task itself you can specify an exception file. Do that and see if it contains any more details than the dts package log.
]]>