Calling a Web Service from DTS

Hi,
I created a DTS Package that is running a Java Script:
var xmlHttp=3Dnew ActiveXObject("Microsoft.XMLHT=ADTP")
xmlHttp.open("POST","http://crm01/InstallName/Ch=ADeckContractExpire.asmx/C=
heckCo=ADntracts",false,"DOMAINNAME\USERNAME",=AD"PWD")
xmlHttp.send()
When running the script from the package it runs fine, and processes
the data as expected. When I convert this to a scheduled job, it fails
with the following error:
Executed as user: CRM02\SYSTEM. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
OnError: DTSStep_DTSActiveScriptTask_1, Error =3D -2147220482 (800403FE)
Error string: Error Code: 0 Error Source=3D msxml3.dll Error
Description: The download of the specified resource has failed.
Error on Line 9 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context:
4500 Error Detail Records: Error: -2147220482 (800403FE);
Provider Error: 0 (0) Error string: Error Code: 0 Error
Source=3D msxml3.dll Error Description: The download of the specified
resource has failed. Error on Line 9 Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 4500 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution complete.
Process Exit Code 1. The step failed.
Any Suggestions? =20
Thanks=20
BillHi All,
I deleted the step out of the Job, and recreated a new step and
change the type to ActiveX, and selected the JScript. I dropped the
code that I generated from the Packaged and executed the Job with No
Errors. I then scheduled the Job and it works fine. Not sure what's
going on, but I have it working.
Bill