SSIS

Background:The OLTP data source is from WebService, we want to pull this data into the specified tables of sql server. How can we do this? In this article, i will show you a simple example to call a Web Service from SSIS and store the results in a file, then insert into database. Solution:Pa...