This is a general question, i'm trying to figure out how to import a JSON file from a rest API (Link Below) using SSIS. I've never worked with this type of data before, and every where I look, they want you to purchase a tool to do this, we don't have the budget to buy any tools. Any help or examples would be really great. Thanks!
Open in new window
and if you look at more details here: https://www.pauric.blog/How-To-Import-JSON-To-SQL-Server/ they actually show exactly how to import "...the JSON is from an API call for a set of land parcels from a virtual reality platform (to make things interesting 🦕):"
If you really want to use SSIS to perform the import then I believe the link https://www.cdata.com/kb/tech/json-ssis-task-import-2008.rst will show you just how to do that.