SSIS, WebService and Http connection manager error

[arajendran]

Hi guys,

I am trying to configure a webservice connection for uploading an XML file. I am able to reach the website from my browser but when I try to configure an http connection manager, I'm getting the "unable to connect to remote server" error.
We have a proxy server that we use and I've included that information in the connection manager in he Proxy section using the format: http://IP:Port

i'm still getting the same error. But it works through my browser, should I configure something else for this to work through SSIS?

Also, I only have SQL 2005 client tools installed on my laptop on which I am trying to set up the webservice. All i'm trying to do is upload an xml file, which stored locally on my laptop, to a webservice site. Our database server is not connected to the internet and hence I am trying to email the generated xml file from my laptop. Could that be a problem. Does the SSIS project have to reside on a box that has the server components installed?

Any help is much appreciated.

Regards,
Anna.

[arajendran]

Hi Guys,

It works now, all I did was delete the old http connection and create a new one and it worked. Bit wierd...anyway thought you should all know, also it works just fine with client tools, you don't require server components.

Have a great Friday!
-Anna.