103 Web Service task in SSIS | How to use Web service task in SSIS

[@reddyabhik]

I really liked this video demo on how to access file using web service connections using ssis. It is very much helpful. Thank you for taking effort to post this video

[@learnssis]

Thank you so much.

[@ExonaQ]

Thank you , we need more web service video

[@learnssis]

Yeah will try to make in future.

[@ladislavkoudelka6953]

Hello, I have a problem with WSDL definition. In the web service task editor, I successfully download the wsdl, then I select the service and method in the input tab and get the message ""The selected Web method contains unsupported arguments". The application SoaPUI processes the wsdl file and calls the service successfully. Do you know where the problem could be? Thank you

[@shreedhartardekar8406]

can we consume api like we test in Postman? e.g. can we extract data from api endpoint and then load it into sql server table. and what if i want to get data in json format instead xml

[@learnssis]

yeah we can get data from api when it is returning data in Json format and can import it to a sql table. kzbin.info/www/bejne/q4q8p36MasiWmq8

[@koushaljha4507]

very useful

[@learnssis]

Thank you Koushal Sir.

[@angiewang1556]

hello, thank you for the video but why when I create new text file and try rename to wsdl or xml file, it doesn't make the change? thank you.

[@learnssis]

Are you using the same web service that I used in this example ?

[@saikumar-os2rg]

where do we use the web service task in real time scenarios can you tell that please

[@learnssis]

Sometimes the client provides data through web service task on which you can work. For example there is a legacy software which stores the data in its own format like in .dat file or some encrypted files, but they provide a way that you can access the data using web service and can insert that data into may be sql server. So you can use web service task to pull the data and store it in xml format, later you can import the xml file into sql server database.

[@ExonaQ]

i had to use in real life scenario when i had to verify if a phone number is correct or no , and its carrier so in this case i needed to use a web service

[@learnssis]

@@ExonaQ Okay.