Windows 2k SP3, SQL 2k Standard Edition SP3 (ver. 8.00.760)

I have a dts package that imports a fairly large Foxpro table (3.4
million rows) to an Sql Server table. This package had been running
smoothly for 3 years and then it started to fail intermittently. I know
it is not a problem with the data since the same data is imported and
overwrites the exiting SQL table. The destination table is dropped &
re-created before before the data is copied.

When I run the package in DTS I either get an "unspecified error" or an
error box popup with no text(!) and an OK button. This happens whether
I run the package in EM or as a scheduled job.

The Foxpro file contains 8 years worth of data. I was able to resolve
this problem in the past by breaking the migration down into 1 year
chunks (multiple steps in dts package). Then after a year it started
failing again so I broke it down futher into 3 month chunks, now 6
months later, it is failing againand seems to work if I break it down
into 1 month chunks. In

The strange thing is it is not consistent. Sometimes the same 1 month
chunk (i.e. Jan 2003 data) won't work, then when I run it again a few
minutes later it works.

What I've tried: I checked permissions and everything seems to be in
order. As I mentioned earlier, I can somethimes get 1 month chunks to
run in EM. I created a maintenance plan and ran it as mentioned in one
post. I am at a loss on how I will fix this. I am attaching part of the
log file below. Help!

Thanks,
Pali

Log file contents:

Step 'Create Table [MyDB].[dbo].[table1] Step' succeeded
Step Execution Started: 2/21/2005 10:30:33 AM
Step Execution Completed: 2/21/2005 10:30:34 AM
Total Step Execution Time: 0.109 seconds
Progress count in Step: 0

Step 'Copy Data from foxTable to [myDb].[dbo].[table1] Step' failed
Step Execution Started: 2/21/2005 10:30:34 AM
Step Execution Completed: 2/21/2005 10:30:45 AM
Total Step Execution Time: 11.781 seconds
Progress count in Step: 0