A SQL Agent job that executes a DTS package to perform a basic database copy from one server to another has started failing with “Error string: Invalid OLEVERB structure”.
We’ve checked MDAC versions on both servers and the agent has permissions on the SQL Server\80\Tools directory. The agent runs as a low priv user and has no problems running other jobs.
The DTS package runs fine when executed manually. We’ve done registry and windows security comparisons between this server and others that are fine and found no differences.
What does “Invalid OLEVERB structure” mean and why does this error occur?