Read data from API and load it into SQL Server using SSIS

Question

Hi all,

I have inherited a SSIS package where it reads data from a file folder location using a software called Zappysys and then loads it into a table.

The file in the folder is the output from an API url and I have tried to look everywhere but struggling to find out the process that saves the API output in the file folder location.

What am I missing out please? Desperately in need of some help!

Thank you!

Answer 1

Hi @Sweta,

Zappysys is a third-party component, I'd like to suggest that you may post the issue to Zappysys for more advice.

Here is an official documentation provided by Zappysys, you may take a carefully reference.

In addition, if you want to load data from API to local file or sql table, you may refer to below links.

https://www.zealousweb.com/calling-rest-api-from-sql-server-stored-procedure/

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.