DTS RUN failing: Index file not fuond

[christer99]

Getting "index file not found" when running a DTS / Dbase 3 import to SQL. It is working on two servers, but not the third one.

DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error string: Index file not found. Error source: Microsoft JET Database Engine Help file: Help context: 5003256 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -334894071 (EC09EC09) Error string: Index file not found. Error source: Microsoft JET Database Engine Help file: Help context: 5003256 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnProgress: DTSStep_DTSDataPumpTask_3; 1000 Rows... Process Exit Code 1. The step failed.

 

[mrdenny]

Check witht he Dbase3 folks. You are getting the error from Dbase.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com