Search results seem to indicate this problem shows up ocassionally but I
haven't found any solutions. Anyone here have a similar experience and find
a solution?

DTS import package that transforms a dozen foxpro dbf files to SQL server
2000 tables has been running reliably for over a year. To my knowledge
nothing has changed unless a windows update modified part of the OS. The
package consists of 2 connections with 12 transformation tasks between them.
Most of the transformations are simply "copy column" but there are also
several activeX transforms to deal with blank dates in the foxpro dbf files.
[if 1900 then null]

SQL server 2000 SP3 running on server 2000 SP4.

This error stared appearing a couple weeks ago and I can't get the package
reliable.
Application popup: DTSRun.exe - Application Error : The instruction at
"0x77fccc79" referenced memory at "0x0000e43d". The memory could not be
"read".

I have disabled multi-threading on the package and de-selected "use
transactions"
At least now the package completes sucessfully without rolling back the
imports but every morning I have to clear the console error on the server.

In response to an article I found yesterday I went into the workflow of the
final transformation task and checked "close connection". Still no luck.



HELP!

Dale