LoadFromSQLServer failed - OLE Automation Error

[madhouse]

When I run a stored procedure that executes a DTS Package I get the the following error:

*** LoadFromSQLServer failed [SQLSTATE 01000] (Message 0) OLE Automation Error Information [SQLSTATE 01000] (Message 0) HRESULT: 0x80040e14 [SQLSTATE 01000] (Message 0) sp_OAGetErrorInfo failed. [SQLSTATE 01000] (Message 0). The step succeeded.


But if I run execute the DTS Package manually it works fine!! What is wrong??

 

[markVII]

Usually this error is associated with MS Access, points to syntax error
Seems like a security problem; make sure that the scheduled DTS runs in the same privilege context as your manual execution (the one you connect with)