question

KeerthiChebrolu-8791 avatar image
0 Votes"
KeerthiChebrolu-8791 asked ZoeHui-MSFT edited

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

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 @SSIS 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
odata-failure.jpg (144.3 KiB)
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.

1 Answer

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

Hi @KeerthiChebrolu-8791,

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



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.