Get data from sharepoint list using SSIS

rajanisqldev-42 206 Reputation points
2021-05-19T08:52:39.6+00:00

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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,412 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 30,411 Reputation points
    2021-05-20T01:14:29.61+00:00

    Hi @rajanisqldev-42 ,

    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

    0 comments No comments

  2. rajanisqldev-42 206 Reputation points
    2021-05-20T10:39:25.147+00:00

    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