Rapaport TechNet
 
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 https://technet.rapaport.com/webservices/prices/rapaportprices.asmx)
2. I am able to download wsdl file locally.by 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
Purva
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,

Regards,

Leo
>> 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 
https://technet.rapaport.com/webservices/prices/rapaportprices.asmx
that means it is https and not http.
 

anybody ever tried with SSIS?

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