Re: DTS export to Excel with VB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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:
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@xxxxxxxx> wrote in message
news:1159565890.420971.132240@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: ORA-03117 resulting from package procedure parameter record types
    ... I am at a client who has recently migrated from Oracle 7.3.4 to Oracle ... number of the package procedures, ... procedure proc1 is ... bind variables fails with the oracle error message "ORA-03117: ...
    (comp.databases.oracle.misc)
  • Re: Package Load Failure
    ... > After some days working fine, I am getting an error message when I try to ... > load my device application project. ... > "Package Load Failure ... > Package 'Smart Device Project Package' has failed to load properly (GUID ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Thoughts about finding viruses in email inboxes
    ... The key I used was the one from the error message. ... I would expect the gpg key for package verification to ... The problem was/is being able to authenticate the d/l server. ...
    (Ubuntu)
  • Re: Thoughts about finding viruses in email inboxes
    ... The key I used was the one from the error message. ... I would expect the gpg key for package verification to ... The problem was/is being able to authenticate the d/l server. ...
    (Ubuntu)
  • Re: mozilla-firefox 0.8-5 cant add bookmark
    ... "Bookmark this ... > As the error message indicates, the XML file is not properly formatted ... i ended up building the package from source ... (apt-get source -b mozilla-firefox), and that worked. ...
    (Debian-User)