dbTalk Databases Forums  

Error while exporting SQL Server 2000 data to excel through DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error while exporting SQL Server 2000 data to excel through DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jimgeo
 
Posts: n/a

Default Error while exporting SQL Server 2000 data to excel through DTS - 03-20-2009 , 09:10 PM






I am getting a strange error after some XP build updates on my machine. I
have a MS Access application (Front End) and back end is SQL Server 2000.
The table data is exported to excel from MS Access using a DTS package file
using ADODB.
The error I am getting is "The number of failing rows exceed the maximum
specified and database is read only", where as when I run the package from
Enterprise Manager it works fine.

I tried to debug the problem but it fails at DTS.execute procedure.

Any suggestions?

--
JimGeo

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.