How to import data from a web service to database by SSIS package

[1700 views]


This tutorial is about a solution which calls a web service from a SQL Server Integration Services package, deserialize the JSON result and store the data in the SQL server tables.

Steps

  1. Create a table with the columns according to the data received from the JSON response calling the webservice.

    create table

  2. Create a SSIS package and in the Data Flow task, add a Script task. The script task will contain the code for calling the webservice and creating the JSON response.

    script task

  3. In the C# code, call the webservice(SOAP/REST) link and fetch data.
  4. Using a foreach loop, deserialize the JSON result and returns the result in a JSON object.
  5. Create a OLEDB destination in the SSIS package, and fetch the result from the script task into the SQL database table.

    oledb destination

        

Algorithm Logic Test

Our Quiz prepared by Experts Helps you identify your knowledge in Algorithms. Everyone should atleast attempt this Quiz Once. 



Comments



Search
Algorithm Quiz

Are You Learning Computer Algorithms? Check Your Knowledge using our Quiz?

Deals Ends in





Online Games
Play 2048 Game Online and Relax.
Play 2048 Game Online

Search Tags