| Author |
Topic |
|
swekik
Posting Yak Master
126 Posts |
 Posted - 2008-09-24 : 12:47:18
|
| 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"" |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-09-24 : 12:49:38
|
| Exact error message in job is: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. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 13:14:02
|
| Whats the datapump task doing? what's your source &destination connection? |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-09-24 : 13:17:18
|
| It will load data from a table to a destination excel fileSource is table and the destination is excel file on a shared drive |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 13:25:13
|
quote:
Originally posted by swekik
It will load data from a table to a destination excel fileSource is table and the destination is excel file on a shared drive
seems like you had kept excel file open when you ran DTS which caused this error. |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-09-24 : 13:33:25
|
| No,Its not opened.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 13:35:25
|
quote:
Originally posted by swekik
No,Its not opened..
can you check if excel file exists with read only attributes? |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-09-24 : 13:39:34
|
| No.It has full rights.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 13:58:35
|
quote:
Originally posted by swekik
No.It has full rights..
just to test can you try giving a new excel file as destination and try running it? |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-09-24 : 14:19:46
|
| I tried like that also but its failing.... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 14:32:27
|
quote:
Originally posted by swekik
I tried like that also but its failing....
A new file or already existing excel file? |
|
|
|
|
DTS Error