MS SQL Server DTS - Error Code : -2147023898 occured while executing Activex Script from stored proc

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Error Code : -2147023898 occured while executing Activex Script from stored proc

irfankhanpatha via SQLMonster.com

2005-09-30, 7:23 am

Dear All,

I have made a Activex Script(VB Script) package (Local Package) in MSDE 2005.
In this package I am creating XMLDOM Object. This package works perfectly
well when I m executing it from (By right clicking it in) enterprise manager.

But this error " -2147023898" occurs when I m executing the same from a
stored procedure. I am not able to create XMLDOM Object. Even I m not getting
error description, it is only giving me error number (err.number).

Can some one please help me out.

Thanks

Sponsored Links