dbTalk Databases Forums  

dBase, Jet 4 sp7 & Win 2k sp4

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


Discuss dBase, Jet 4 sp7 & Win 2k sp4 in the microsoft.public.sqlserver.dts forum.



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

Default dBase, Jet 4 sp7 & Win 2k sp4 - 08-06-2003 , 01:26 AM






Does anyone know of a problem with the MS Jet 4 Service
Pack 7 (4.00.6807.0) that comes with Windows 2000 Server
Service Pack 4 when running SQL Server 7.0 Service Pack 4
DTS (Data Transformation Service) to transfer data from a
SQL Server table to an empty dBase III Plus (using the
dBase IV driver) .dbf table. I get the following error
on only the most complex one of six tables involved:

Step Error Description:Catastrophic failure
Step Error code: 8007FFFF

This process has been running nightly since 09/2000 and
just failed after the Win2k sp4 update.

I had a Windows95 machine that was working with a
downlevel version of Jet 4.0. After I upgraded it to
sp7, it also now continuously fails on the same complex
table. Also, after the upgrades, SQL Server Enterprise
Manager abends when I attempt to open the Destination tab
(the dBase Connection) in the Transform Data Task
Properties for the DTS Local Package in question. Thanx!

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.