Developer Forum [ All Topics | New Topic ]

Thread: Getting Rapaport Price List using SQL Server Integration Service

I am trying to download Rapaport Price using SQL Server 2008 Integration Service. I took following objects :
1. http connection manager (defining
2. I am able to download wsdl file placing ?wsdl in the above link and clicking download file.
3. I placed 2 webservice task one pointing to login method and other pointing to GetPriceSheet Method.
4. linked login method to getpricesheet method.
5. When I run the package it gives error 
The Web Service threw an error during method execution. The error is: Server was unable to process request. ---> Credentials can only be passed over secure connections (HTTPS).

can anybody help me in this regard.

>> add a comment
01/18/2012 07:25

2 Replies:

The message would indicate that you are doing the request on HTTP and not HTTPS.

Hope that helps,



>> add a comment
Leo Muller
1/19/2012 4:53:00 AM
In SSIS there is only HTTP connection manager and not HTTPS connection Manager . Also in that I am giving link
that means it is https and 
not http.

anybody ever tried with SSIS?

>> add a comment
1/20/2012 6:51:00 AM