DTS PACKAGE PROBLEM - SIMPLE AND CONFUSING

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)

DTS PACKAGE PROBLEM - SIMPLE AND CONFUSING

Author

Topic

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-05-16 : 11:24:39

I have a DTS package with A connection a source file and a Data Driven Query Task. When I run the package I get this error:

connection 'Microsoft OLE DB Provider for SQL Server' for task 'Data Driven Query Task ' does not support joining distributed transactions or failed when attempting to join. Unable to Enlist in Transaction. New Transaction cannot enlist in specified transaction coordinator.

Weird thing is when I make copies of all the 3 and paste in the same DTS package one package Fails and One Runs. But If I delete any original connection or task both the packages fail.

I don't know why this error started coming. There might be an easy fix to it coz when there are 2 copies one runs successfully.

Anyone faced the same thing.

Ashley Rhodes

dpearcy
Starting Member

1 Post

Posted - 2007-05-16 : 11:35:29

I'm having an error msg with a DTS package.
The error is 8004043B. From what I've read, it looks like some type of conflict in memory. I'm very green in the SQL world and need some inputs on this error. Your help is appreciated.

Details on Error:

DTSRun: Loading...

DTSRun: Executing...

DTSRun OnStart: DTSStep_DTSActiveScriptTask_1

DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B)

Error string: The task reported failure on execution.

Error source: Microsoft Data Transformation Services (DTS) Package

Help file: sqldts80.hlp

Help context: 1100

Error Detail Records:

Error: -2147220421 (8004043B); Provider Error: 0 (0)

Error string: The task reported failure on execution.

Error source: Microsoft Data Transformation Services (DTS) Package

Help file: sqldts80.hlp

Help context: 1100

DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1

DTSRun: Package execution complete.

Thanks,
David

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-05-18 : 17:15:06

Forgot to mention that the package runs fine on the server but give the error when try to execute from the client.

Ashley Rhodes

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-19 : 20:43:47

David, what does your package do? Did you run it as sql job?

Ashley, how did you run the package from client machine? Where are packages stored?

Cybergoose74
Starting Member

3 Posts

Posted - 2007-06-18 : 09:03:01

I have a DTS package that is running on a client PC (VB6 app downloads DTS 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
****************************************************************************************************

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources