When my DTS pkg is running, I get this error. It is the first time it
has come up and I am not sure what the error means or where to begin.
The error description makes me think it has something to do with the
OLE DB Provider (which is connecting to an MSDE 2000 sp3 database).
Any ideas? Also, where can I find a complete list of all error codes?
I cannot even find a reference to 64222 in BOL or MS website

This is from my execution log. The task that is failing is a Data Pump
Task...

Step 'Inserting data for CD_EMPLOYEE' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Provider generated code execution exception:
64222
Step Error code: 8004FADE
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4700

At what point does this happen?

Is this from the Exception file in the package or the task itself.

Are both sides of the DataPump SQL Server?



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"jle" <joeyebright (AT) decadesoftware (DOT) com> wrote

There are about 120 data pump tasks, each moving data for a table. The
source is Sybase Adaptive Server Anywhere and the destination is an
MSDE database. What is weird is this problem does not happen all the
time, it is intermittent. This is the error from the task itself. At
the top of the exception file, I found a different error. Here it is:

The execution of the following DTS Package failed:

Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description:Package failed because Step 'Inserting data for
CD_EMPLOYEE' failed.
Error code: 80040428
\Error Help File:sqldts80.hlp
Error Help Context ID:0

I would still favour a login problem.

Slow link?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"jle" <joeyebright (AT) decadesoftware (DOT) com> wrote

Thanks for your thoughts Allan. As for the login, would you think that
possibly their connection got dropped? We have experienced that before
(faulty network card) and the error is quite specific (and different)
in that case. I am interested in what you mean by slow link. Are you
thinking that possibly the server could not respond in time to the
request for data?

Correct. Maybe it could not authenticate you because the details sent were interpreted badly/could not validate you on the domain,
too slow, server was busy

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"jle" <joeyebright (AT) decadesoftware (DOT) com> wrote

Thanks for the response. I will see what we can do to monitor the
server during the execution of our DTS package. Perhaps that will shed
light on things. Thanks!