We have been running DTS packages on SQL2000 on a 2nd instance.

We have moved the databases to a different server and saved the DTS packages
to the new server (by opening the package and performing a save as to the new
server).

We are having a problem with some of our DTS packages

The DTS packages can be executed without error by a Domain Admin user
account from within enterprise manager, but we need them to run by being
called from a stored procedure. This stored proc uses the extended "sp_OA"
stored procs. When the problem packages run from the stored proc we see the
following errors in the log file:

LoadFromSQLServer failed [SQLSTATE 01000]
OLE Automation Error Information [SQLSTATE 01000]
sp_OAGetErrorInfo failed. [SQLSTATE 01000]

Please let me know if you have some idea what might be causing this

Thanks