Hi.

I have a DTS package that contains about 15 tasks to
transfer data from a sql server database to oracle (8.05).

When i execute the task, the first 4 tasks are run and
then i get a "the number of failing rows exceeds the
maximum specified limit" error. Yet, the data is loaded
into oracle for the first 3 steps.

I've created an exception file to report the errors.
This is seen below. Where can I find out why my data
won't load, and what is error code 80004005? I able to
load this data from a different sql server into oracle.

Thanks.

================================================== ========
DATA TRANSFORMATION SERVICES: Data Pump Exception Log


Package Name: ClienTellTransfer
Package Description: Sql to Oracle
Package ID: {412FF6AE-F6EE-4C03-B83B-B1291775FDFE}
Package Version: {9CAEEFE4-FD16-4972-9C47-498149B23540}
Step Name: Copy Data from USERS to USERS Step

@@ExecutionStarted

Execution Started: 4/8/2004 2:28:32 PM

@@LogSourceRows: C:\ClienTell\Transfer\Users.txt.Source
@@LogDestRows: C:\ClienTell\Transfer\Users.txt.Dest

@@ErrorRow: 1
Error at Destination for Row number 1. Errors encountered
so far in this task: 1.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logging Failed

Error code: 8007000E


@@ErrorRow: 2
Error at Destination for Row number 2. Errors encountered
so far in this task: 2.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logging Failed

Error code: 80004005


@@ErrorRow: 3
Error at Destination for Row number 3. Errors encountered
so far in this task: 3.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logging Failed

Error code: 80004005


@@ErrorRow: 4
Error at Destination for Row number 4. Errors encountered
so far in this task: 4.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logging Failed

Error code: 80004005


@@ErrorRow: 5
Error at Destination for Row number 5. Errors encountered
so far in this task: 5.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logging Failed

Error code: 80004005


@@ErrorRow: 6
Error at Destination for Row number 6. Errors encountered
so far in this task: 6.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logging Failed

Error code: 80004005


@@ErrorRow: 7
Error at Destination for Row number 7. Errors encountered
so far in this task: 7.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logging Failed

Error code: 80004005


@@ErrorRow: 8
Error at Destination for Row number 8. Errors encountered
so far in this task: 8.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logging Failed

Error code: 80004005


@@ErrorRow: 9
Error at Destination for Row number 9. Errors encountered
so far in this task: 9.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logging Failed

Error code: 80004005


@@ExecutionCompleted

Execution Completed: 4/8/2004 2:28:32 PM

************************************************** ********
******************************************

This error 80004005 means that there is an Access Violation. This could
either be a permissions for insert problem or it could be that the server
has disappeared.

make sure you have permissions to the log file as well and enough disk space
all round.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Tracey" <tracey.lemer (AT) itsservices (DOT) com> wrote