<andree_noel@yahoo.ca> wrote in message
news:1159565890.420971.132240@m7g2000cwm.googlegroups.com...
> 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
>

Senthilkumar wrote:
> 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@yahoo.ca> wrote in message
> news:1159565890.420971.132240@m7g2000cwm.googlegroups.com...
> > 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
> >