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

Подписаться 34 тыс.

Просмотров 6 тыс.

50% 1

Web Service task in SSIS | How to use Web service task in SSIS
Web service link: www.dneonline.c...
Download the file\script used in the Video from below link
drive.google.c...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
web service task in ssis
How to use Web service task in SSIS
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”

Опубликовано:

15 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 15

@reddyabhik 2 года назад

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 2 года назад

Thank you so much.

@shreedhartardekar8406 2 месяца назад

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 2 месяца назад

yeah we can get data from api when it is returning data in Json format and can import it to a sql table. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uYYvKV5ccdM.html

@ladislavkoudelka6953 2 года назад

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

@ExonaQ 2 года назад

Thank you , we need more web service video

@learnssis 2 года назад

Yeah will try to make in future.

@angiewang1556 2 года назад

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 2 года назад

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

@saikumar-os2rg 2 года назад

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

@learnssis 2 года назад

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 2 года назад

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 2 года назад

@@ExonaQ Okay.