SSIS package with Active X Script task error

angupta used Ask the Experts™
I've one SSIS package which uses Active X Script task. Now, this package runs fine from VS; but when I try to run it through SQL Server 2005 job, I get following error- - "Retrieving the file name for a component failed with error code 0x1ADBD638"

There is an error in this function below--
Sub PostXML()
    Set objXMLHttp=CreateObject("msxml2.XMLHTTP")
    Set objXMLDoc=CreateObject("msxml2.DOMDocument")
    strXMLPath = "C:\EmailTemplates\SendEmail.xml"
    objXMLDoc.Load (strXMLPath) "POST", "", False
    objXMLHttp.send objXMLDoc.xml
    If Len(objXMLHttp.responseText) > 0 Then
        objXMLDoc.async = True
        objXMLDoc.loadXML (objXMLHttp.responseText)
     End If
End Sub

Open in new window

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial