Hi, I've been using a stored procedure I found on databasejournal.com for some time. The stored procedure,
spExecutePKG, allows you to kick off a DTS package from withing a T-SQL statement. The procedure was working fine up until a few days ago. Now, when I try to run it I receive the following error:
*** Execute failed
OLE Automation Error Information
HRESULT: 0x80040428
sp_OAGetErrorInfo failed.
Not only is the spExecutePKG proc failing, but the sp_OAGHetErrorInfo proc is failing to retrieve any detailed information about the failure. Has anyone else come across this issue?
spExecutePKG, allows you to kick off a DTS package from withing a T-SQL statement. The procedure was working fine up until a few days ago. Now, when I try to run it I receive the following error:
*** Execute failed
OLE Automation Error Information
HRESULT: 0x80040428
sp_OAGetErrorInfo failed.
Not only is the spExecutePKG proc failing, but the sp_OAGHetErrorInfo proc is failing to retrieve any detailed information about the failure. Has anyone else come across this issue?