Hi

SQL2K, Win2K.

I have 2 data pump tasks that load data from a source db to a target
db. They can run synchronously (together, ie. no precedence). I can
execute each of them on their own, and they run fine, but when I run
the package, I get an 'unspecified error'.

This is what I get in the log file:
----------------------------------------
Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Unspecified error
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0
----------------------------------------

Quit helpful, don't you think?

Any ideas? As I said, I can execute each of them on their own, but
when I run the package it fails. And it fails on whichever of the two
is executed last, it seems. ie. Run it once and datapump1 fails, run
it again and datapump2 might fail (if it decides to run 2 last...)

thanks
sean

80004005 generally means 1 of two things although it is a generic error

1. Object does not exist
2. Permissions are wrong

From your description perhaps you have some locking caused by the dual pump.
Do you have TABLE LOCK set on the last option of the datapump for either or
both of the datapumps?

You can view locking on Source and Destination providing they are SQL Server
using Profiler or sp_who2
--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sean" <plugwalsh (AT) yahoo (DOT) com> wrote

Hi

Just an update:
The problem was caused by having comments ("--") in the code for these
& other tasks. Removed them and they ran ok. Put in /* */ comments and
that ran fine, too. Looks like comments mess up the transform data
tasks, especially if you've got parameters involved.

Cheers
sean




"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Good catch. I have had this problem also.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sean" <plugwalsh (AT) yahoo (DOT) com> wrote