I went to Visual Studio -> Buisness Intelligence -> Create New Project
All i need to do is..
Extract the response from wsdl to mt SQL table, so I dragged WebServices Task, from the left, and ther in, General -> Http Connection -> I gave
Note: The url above is not the actual url, but works absolutely fine.
Upon hitting the Test Connection - button, I get the Msg test connection Succeeded.
Now in the General tab, I fill in the other info like wsdl files(pointing to the wsdl file I created)/ Override WSDL to true/Gave the Name and Description, then upon hit of Download WSDL button, I get the pop up msg as
SSL Certificate Response obtained from the server is not valid. Cannot Process the request