I have stored procedure that runs a dts. This dts connects to a server by
post and receives a XML. When I run the dts directly it works, but from the
sp it give me the following error:
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
(800403FE)
Error string: Error Code: 0
Error Source= msxml3.dll
Error Description: A connection with the server could not be established

any ideas??