June 2, 2004 at 6:06 am
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 execute the DTS Package manually it works fine!! What is wrong??
June 7, 2004 at 12:23 pm
Can you post how you are performing in the SP and are you on the server when manually running the DTS and are you using the same login account to execute the SP.
June 9, 2004 at 2:13 am
Thanks for your reply requesting further information, but I was playing around last night and have now got it to work. Not sure what I did differently but hey at least it's now working.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply