question

RajMaddala-5812 avatar image
0 Votes"
RajMaddala-5812 asked ZoeHui-MSFT edited

Get data from sharepoint list using SSIS

Hi

I am reading data from sharepoint list using SSIS OData source.

It is working until last week from months.

Suddenly failing from yesterday. When I test connection at design time, test connection succeeded.

When I execute the package, I am getting error "Cannot acquire a managed connection from run time data source..."

What is this error?

How can I fix the issue?

Regards

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @RajMaddala-5812,

Here is a same error yesterday odata-error-cannot-acquire-a-managed-connection-fr.html

Someone got this error since proxy was enabled in the server.

SSIS Package is not able to access Sharepoint List during execution when the proxy is enabled.

This is working fine after changing the connection to "automatically detect settings" in the internet options.

You may have a try.

Here are some other detailed resolution in this link, you may carefully refer to see if it will be useful.

Regards,

Zoe


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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RajMaddala-5812 avatar image
0 Votes"
RajMaddala-5812 answered ZoeHui-MSFT edited

Hi Zoehui-MSFT,

Thanks for the reply. Where do I need to change "Automatically detect settings"? I can't find this in ODataSource connection

Regards
Raj

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RajMaddala-5812,

Go to the Control Panel > Internet Options > Connections tab and then click on LAN settings.

98436-screenshot-2021-05-21-142044.jpg
https://docs.microsoft.com/en-us/troubleshoot/browsers/automatically-detect-settings-enabled

0 Votes 0 ·