Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

index file missing Dbase3 to SQL DTS import

Status
Not open for further replies.

christer99

IS-IT--Management
Dec 3, 2001
247
When I do an import via SQL DTS from Dbase3 (to SQL MSDE), I am getting error saying the index file is missing although it is there (an .NDX file). The same DTS packages works fine on another server using SQL 2000 Standard edition, but not on MSDE. The funny thing is that two of other dbase table imports from the same directory are working, but not this particular table. I can't figure out why. Any ideas? Also, the other difference, besides MSDE and SQL 2000 Standard Edition, is that is failing on MS 2K Advanced Server, but working W2003 server.

Microsoft Windows 2000 [Version 5.00.2195]
C:\Documents and Settings\Administrator>DTSRun /N "test45" /V "{35849260-0DCE-48
F8-8A3F-CF036F8A0CF7}" /F "C:\ARP\test45.dts" /W "0"
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, 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_1
DTSRun: Package execution complete.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top