Showing posts from May, 2017

SSIS - Pull the data from Web service (REST API)

I got opportunity to pull the data from web service and load into SQL database. SSIS 2014 have one web service task but that was not suitable for REST API. In order to achieve this, we need to use script component in the data flow task. double click on the script component and can provide required variables. now go to the editor and add reference to web extensions. Project --> add reference --> browse and choose system.web.extensions.dll. now balance scripting is very easy even if you are not aware of C# coding. include all the required name spaces as displayed below. #region Namespaces using System; using System.Data; using Microsoft.SqlServer.Dts.Pipeline.Wrapper; using Microsoft.SqlServer.Dts.Runtime.Wrapper; using System.Net; using Microsoft.SqlServer.Dts.Runtime; using System.Windows.Forms; using System.IO; using System.Web; using System.Xml; using System.Collections.Generic; using System.Data.Sql