troubleshooting Question

Importing JSON Rest API into SQL Using SSIS

Avatar of Junior Vasquez
Junior Vasquez asked on
JSONRESTSSISSQL
5 Comments1 Solution101 ViewsLast Modified:
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!

https://opendata.arcgis.com/datasets/aa514416aaf74fdc94748f1e56e7cc8a_0.geojson
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros