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

Irawan Fajar 1 Reputation point


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,


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

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 27,466 Reputation points

    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.


    Zoe Hui

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

    0 comments No comments