SSIS Error OData "The Application ID (AppID) for which the service ticket is requested does not exist on the system"

Question

Hi,

I have Visual Studio 2019 with SSIS Extension installed and already created and deployed SSIS package with OData connection manager to get sharepoint online data.
But after a windows / security patch on my machine, the OData connection manager always gets error message:

"The Application ID (AppID) for which the service ticket is requested does not exist on the system. (Microsoft.SqlServer.IntegrationServices.ODataConnectionManager)"

I tried the usual adding SchUseStrongCrypto registry and enforce tls 1.2 on my machine again. But still the error still persists.
I cannot use system restore, because it's disabled by our system administrator.

Appreciate your help in advance,

Irawan

Answer 1

Hi @Irawan Fajar ,

Could you please edit the package via Visual Studio to re-configure the OData connection manager?

The OData source includes support for the following data sources:
Microsoft Dynamics AX Online and Microsoft Dynamics CRM Online
SharePoint lists. To see all the lists on a SharePoint server, use the following URL: https://<server>/_vti_bin/ListData.svc. For more information about SharePoint URL conventions, see SharePoint Foundation REST Interface.

You may click test connection to check the connection.

Check tutorial-using-the-odata-source to see if it is helpful.

Regards，

Zoe Hui

---

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