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.
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.