If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: sp_OAMethod @oPKG 'Execute' problem

Hi All!
I try to execute DTS package which suppose to export table to flat file from SQL script. I'm not getting any errors from script but it looks like package is not running. The Package works fine from EM and the same script works fine on VBscirpt.

Hi,
Thanks.Sure, I tried to run it in sp_start_job stored procedure before, but I found out the problem now. It requires full network path and also to figure out error I set up FailOnError packages property

But if execution is failed, I still can not get error description, just a message "sp_OAGetErrorInfo failed" with hex number. Probably it is not possible to find out some errors for Steps using sp_OAGetErrorInfo.

Hi,
Thanks.Sure, I tried to run it in sp_start_job stored procedure before, but I found out the problem now. It requires full network path and also to figure out error I set up FailOnError packages property

But if execution is failed, I still can not get error description, just a message "sp_OAGetErrorInfo failed" with hex number. Probably it is not possible to find out some errors for Steps using sp_OAGetErrorInfo.