September 24, 2008 at 11:13 am
I am getting a DTS package error.I am trouble shooting this from longtime.can any body help me in this??
""the number of failing rows exceeds the maximum specified.cannot update.database or object is read only""
DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217911 (80040E09) Error string: Error at Destination for Row number 1. Errors encountered so far in this task: 1. Error source: DTS Data Pump Help file: Help context: 0 Error Detail Records: Error: -2147217911 (80040E09); Provider Error: -118490897 (F8EFF8EF) Error string: Cannot update. Database or object is read-only. Error source: Microsoft JET Database Engine Help file: Help context: 5003027 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147213206 (8004206A) Error string: The number of failing rows exceeds the maximum specified. Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 Error Detail Records: Error: -2147213206 (8004206A); Provider Error: 0 (0) Error str... Process Exit Code 1. The step failed.
September 24, 2008 at 11:33 am
This looks significant:
Database or object is read-only
September 24, 2008 at 12:21 pm
No They r not in Readonly mode
September 24, 2008 at 12:47 pm
Error string: The number of failing rows exceeds the maximum specified.
I've seen this before using a DTS package that imports data from Excel into a table. It's usually because of a missing data point or some hidden character that causes the DTS to pick up "blank" rows from the spreadsheet.
What's the DTS step that is failing supposed to do?
_____________________________________________________________________
- Nate
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply