Friday, February 24, 2012

JET Database Engine error

I've seen other postings for this error, but I wanted to see if anyone had something a little more solid on how they resolved the issue. When trying to execute a dts package I'm receiving the error:

the number of failing rows exceeds the maximum specified. (Microsoft Jet Database Engine (80004005). Could not update; currently locked. Does anyone have any suggestions? Thanks in advance!yeah, you've probably have data that is corrupt...

Can you modify so it goes in to a table with no contraints?

Where is the file coming from (where is it going)?

It's probably going to be dup primary key, validation rule exception, fk problem, or some other constraint...

just a guess...

No comments:

Post a Comment