SSIS 2017: hangs for a long time before erroring out when trying to connect to data.medicare.gov

Question

SSIS 2017: hangs for a long time before erroring out when trying to connect to data.medicare.gov

vton.flow

SSC Enthusiast

Points: 105
More actions
June 13, 2018 at 3:14 pm

#351490

Can anybody connect to the Medicare odata site?
https://data.medicare.gov/api/odata/v4/4pq5-n9py
https://data.medicare.gov/Nursing-Home-Compare/Provider-Info/4pq5-n9py
I tried v2, v4, http, https, collection, and resource path.
They all hang for a long time then gives an error.
This is one of the errors. I did google it and the solution was to edit the columns, but I can't do it. When I tried to edit the columns, it just hangs for a long time and gives the same error

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

frederico_fonseca SSCoach Points: 16025 More actions · Answer 1

have a look at https://support.microsoft.com/en-au/help/4043104/operation-has-timed-out-connecting-to-odata-using-ssis-in-project-onli

vton.flow SSC Enthusiast Points: 105 More actions · Answer 2

@frederico_fonseca, I'm not using a sharepoint site, what should I put there?

frederico_fonseca SSCoach Points: 16025 More actions · Answer 3

its not being a sharepoint that matters - its is the fact it is a odata request and web request - it applies regardless of the site you are trying to access