HResult variable type and package completion

[JohnDTampaBay]

SQL2K sp3

I have a DTS package that I am running from a stored procedure using the sp_OAMethod OLE automation stored procedure. The stored procedure doesn't capture a package failure correctly.

If I'm reading BOL correctly for sp_OAMethod, it returns "0 (success) or a nonzero number (failure) that is the integer value of the HRESULT returned by the OLE Automation object." So I'm thinking I need to have a global variable in the package defined as HResult type. But I can't add a variable of that type. Every time I try I get an error saying that DTS cannot convert the variable from BSTR to HResult.

How can I accurately capture the package completion code?

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[JohnDTampaBay]

I still haven't figured this out. Any help?

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.