DTS Errors

#1

I have intermittent failures with DTS packages since 8/9. The error
messages I am recieving are cryptic at best. Can anyone help with the
following?

Event Type: Error
Event Source: TaskRunService
Event Category: None
Event ID: 0
Date: 8/28/2006
Time: 10:36:08 PM
User: N/A
Computer: HQEAPP1
Description:
Package Load Complaint Settlements failed, error: xFFFFFFFF800403EC,
xFFFFFFFF80040000 + 1004
Step 'DTSStep_DTSExecuteSQLTask_1' already exists in the collection.

Step Transform data for Complaint Details failed, error:
xFFFFFFFF8004206A, xFFFFFFFF80040000 + 8298
The number of failing rows exceeds the maximum specified. (Microsoft
OLE DB Provider for SQL Server (80004005): [DBNETLIB][ConnectionWrite
(send()).]General network error. Check your network documentation.)

Any assistance traking this down would be appreciated.

Mike W.

#2

jhofmeyr (AT) googlemail (DOT) com wrote:

Quote:

I have a DTS package that is failing on a regular basis but not nightly
meaning sometime it runs fine and sometime it fails. The error I recieved
[quoted text clipped - 9 lines]
--
Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200711/1

Hi Jay,

I believe you'll need to go to Row 8672 in the *source*, not in the
destination. While the destination is throwing the error, it is the
source that is producing the row - as the row has thrown an error, it
is unlikely to have been inserted in the destination. I think that
DTS buckets any "unusual" errors into the "Unspecified error" message.

Good luck!
J

Thanks J for the response I will definitely look at the source information. I
am also recieving the same error in the same package 'Expected the text
length in data stream for bulk copy of text, ntext, or image data'.?
I am not sure what the package is expecting and the research I have turned up
on this is not really specific to what should be done to correct the problem.

--
Message posted via http://www.sqlmonster.com

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

DTS Errors

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

DTS Errors - 08-28-2006 , 10:32 PM

Re: DTS errors - 11-15-2007 , 12:05 PM