question

Queue avatar image
Queue asked

Import Data fromWebservice to SQL Server table

How do i get data from a webservice into sql server table, I only know the link to wsdl and the method names in that, nothing more, how should i proceed?

import-data
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Oleg avatar image
Oleg answered

If you have Visual Studio handy then you can create a project and add web reference to it. When dialog opens specify the address of the wsdl and allow the wizard to proceed. This will generate a proxy class. You can then read the generated types' fields to view what the web service actually returns which will give you all you need to create database table(s) matching the results of the web service call.

You can optionally use the web service task in SSIS. Here is the link to the step-by-step example: http://aspalliance.com/1167_A_StepbyStep_Approach_to_Creating_a_Web_Service_Task_Using_SQL_Server_Integration_Services.1

Oleg

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.