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

Keerthi Chebrolu 1 Reputation point
2021-05-19T11:27:41.373+00:00

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.

97872-odata-failure.jpg

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
    2021-05-20T02:33:10.133+00:00

    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.

    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