Hi,

I have been reading all day trying to figure out this one and I can't
find out why I am having this issue....

I have created a DTS package that export a SQL statement to Excel. The
package runs perfectly in Entreprise Manager, however, when I run the
package in VB, I received the following error:
The number of failing rows exceeds the maximum specified. (Microsoft
JET Database Engine (80040e09): Cannot update. Database or object is
read-only.)

MSSQLSERVER and SQLSERVERAGENT logon with my windows account. I am a
member of the administrators group.

Please help!!!
Thanks
andree

I too had a problem like this and may be you are trying to export a blob
field, where there are problems.

Also, from the options tab, choose the Insert Batch size to 1. This will try
to insert 1 row after another. problematic rows can be ignored.

May be this helps

kesk


<andree_noel (AT) yahoo (DOT) ca> wrote

Thanks for your input, however I still receive the error message. I can
export the package fine from within EM but as soon I try running it
from VB, I get the error message.

I think it might be a permission issue?

Any thoughts???




Senthilkumar wrote: