When I run a dts script, I get the following message during one of the
many tasks that is copying a foxpro database to a sql database -
Cannot open a log file of specified name. The process cannot access
the file because it is being used by another process.
When I run the step alone, I don't get the error. This has worked
before and just started getting the error recently. There is no other
process accessing either the input foxpro database or the output sql
database. Can anyone give me a suggestion about where to look?