Re: General error -2147217900 (80040E14)

#1

Hello Yoshi_DBA,

It would appear this area could mean a lot of things. A good place to start
troubleshooting though is here

http://tutorials.aspfaq.com/8000xxxx...14-errors.html

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:

Step Error Source: Microsoft Data Transformation Services (DTS)
Package
Step Error Description:General error -2147217900 (80040E14).
Step Error code: 80040E14
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:5300
I receive this error when I run the DTS package. The following
behavior is noted:

1. DTS package tends to fail only on monday mornings 2. At other times
this package runs just fine.

* The mystery is why does it *often* but not always fail on monday
morning with the above error message?

The DTS package is designed to import data into a table. It often
fails on
the first step - It creates and makes calls to a COM object (Using
sp_OACreateObject, sp_OA____, etc.) in order to iterate and normalize
some
data before it gets written to the destination table.
But it can fail on other steps as well and the error codes are always
the
same no matter if it fails on the first or last step.
I believe I may have it narrowed down to the usage of the
SP_OACreateObject/SP_OAetc stored procedures (memory issue)
-OR-
It is interfering with some other System level process
-OR-
The amount of records that have to be iterated through may be causing
the
DTS package to bomb out (Hundreds of thousands of records iterated
through
and imported).
Thanks for any clues, insights, or answers!

Best regards,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: General error -2147217900 (80040E14)

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: General error -2147217900 (80040E14) - 12-05-2006 , 03:28 PM