Zone of Development

by Damiano Abballe

Category: ETL

ETL – How to invoke a Web API

In this post, we will see how to invoke, from an ETL, the Web API created in the post: Web API with ASP.NET CORE.We open Visual Studio and we create an Integration Services Project.The first thing that we will do, it is the creation of a project parameter called urlwebapi, where we will insert the […]

Read More

ETL – How to read data from Excel files

In this post, we will see how to read data from an excel files and how to save data into db. We start to create a database called Test and then, using this script, a table called TabExcel: Now, we open Visual Studio 2019 and we create an Integration Services Project: First of all, we […]

Read More