SSIS - OData Connection Issues - SharePoint Project Online - Worked then stopped working

Keerthi Chebrolu 1 Reputation point

Hi Team,

Our SSIS packages were worked fine until yesterday. Suddenly the packages are getting failed.
When i checked the packages, we are received the error messages on ODATA connections in @SIMOHARD package.

We tried service document location (path) used in web, its working fine. we tried the ODATA connection on different app (Power BI ), it working fine.

But in SSIS the ODATA connection is getting failed suddenly. Please check the error message in the below image and help us for solution.


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,403 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 30,411 Reputation points

    Hi @Keerthi Chebrolu ,

    According to my research, the issue can be caused in remote server side.

    For example: the remote server is running, but the service that you're trying to connect to is not available.

    Please have a double the SharePoint project is running well in remote server.

    More details you may also refer this.



    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