'DTSStep_DTSDataPumpTask_1' failed (Error:80040428

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

'DTSStep_DTSDataPumpTask_1' failed (Error:80040428

Author

Topic

Cybergoose74
Starting Member

3 Posts

Posted - 2007-06-18 : 13:14:39

I have a DTS package that is running on a client PC (VB6 app downloads DTS from DB Server and runs locally) that is generating the following error message: any ideas what's causing this? Thanks in advance -JP

****************************************************************************************************
The execution of the following DTS Package failed:

Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description:Package failed because Step 'DTSStep_DTSDataPumpTask_1' failed.
Error code: 80040428
\Error Help File:sqldts80.hlp
Error Help Context ID:700

Package Name: iaEEOB_LMC_Transactions
Package Description: (null)
Package ID: {1110D526-DA27-483C-B6A8-C159FC9A201D}
Package Version: {29DEC7F3-F885-45A5-A2B0-52AB490ED921}
Package Execution Lineage: {CF744A2E-4DF0-4368-9EFB-7F70866EDF91}
Executed On: LMCIMG03
Executed By: vendor
Execution Started: 6/14/2007 8:01:35 PM
Execution Completed: 6/14/2007 8:01:54 PM
Total Execution Time: 19.094 seconds

Package Steps execution information:

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution. (Microsoft OLE DB Provider for SQL Server (80004005): Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.)
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

Step Execution Started: 6/14/2007 8:01:35 PM
Step Execution Completed: 6/14/2007 8:01:54 PM
Total Step Execution Time: 19.078 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_1' succeeded
Step Execution Started: 6/14/2007 8:01:35 PM
Step Execution Completed: 6/14/2007 8:01:35 PM
Total Step Execution Time: 0 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_3' was not executed

Step 'DTSStep_DTSExecuteSQLTask_4' was not executed

Step 'DTSStep_DTSExecuteSQLTask_5' succeeded
Step Execution Started: 6/14/2007 8:01:35 PM
Step Execution Completed: 6/14/2007 8:01:35 PM
Total Step Execution Time: 0.016 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_6' was not executed
****************************************************************************************************

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-18 : 16:17:17

What does the package do? Any listed tasks was running on the server at same time?

Cybergoose74
Starting Member

3 Posts

Posted - 2007-06-19 : 08:42:57

The package parses a data file and updates a couple tables. It is kicked off using a scheduled task and only fails on occasion. No other packages (or tasks) are running at the same time. Once we receive the error, we can reprocess the package manually and everything is fine. This error just started happening in the last month; we've been running for about a year.

What really confuses me is that the error message states that Task_1 failed and then it says Task_1 succeeded. There is nothing about Task_2.

Thanks for you quick reply.

***************************************
More specifically:

* The first step in the DTS package performs an INSERT into a table with three columns.
* The second step TRUNCATEs three different tables that will be used later in this DTS package.
* Then the Transformation happens (puts each line of the data file into another table; FILE_DATA) -- I'm not sure if this is considered a 'task'.
* The next step UPDATEs the FILE_DATA table with a FileID generated in the first step.
* The next step (I think the 4th) performs another TRUNCATE on one of the tables from step 2; I don't know why this is here..could be removed, but I don't think this is causing any harm.
* The fifth step parses the FILE_DATA table and inserts specific fields into a table that was TRUNCATEd in steps 2 and 4.
* And finally, step six UPDATEs the previous table with the same FileID generated in the first step.

***************************************

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-19 : 11:19:21

Ensure backup is not running when you run the package.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources