SSIS package with Active X Script task error

angupta
angupta used Ask the Experts™
on
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")
    
    '*******Inputs********************************************
    strXMLPath = "C:\EmailTemplates\SendEmail.xml"
    '**********************************************************
    objXMLDoc.Load (strXMLPath)
    objXMLHttp.open "POST", "http://xml1.listrak.com/default.asp", False
    objXMLHttp.send objXMLDoc.xml
    If Len(objXMLHttp.responseText) > 0 Then
        objXMLDoc.async = True
        objXMLDoc.loadXML (objXMLHttp.responseText)
        objXMLDoc.Save("C:\result.xml")
     End If
End Sub

Open in new window

Comment
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