OA_types not found error in SSIS when connecting to service now data source

See more:

SQL

SSIS

ODBC

Hi,

We have requirement to pull the Data from Service now source and import it into SQL using SSIS package.
And i followed below steps to bring the data.
1.Created DSN in ODBC driver for Service Now Driver 1.0.14.
2.Then Created Linked server in Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <x64> (Build 14393: ) (Hypervisor).
3.Then then Wrote Open Query to read the data from service now.

But We are getting intermittent issue while connecting and same Service now source is working fine on other Server.
Below Error i get sometime but restart the package resolve this issue.

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "[Linked server Name]".". 
 An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80040E14  
Description: "OLE DB provider "MSDASQL" for linked server "[Linked server Name]" returned message 
"[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Base table:OA_TYPES not found.[10129]

Please Advise.

Thanks in advance
Swapnil

What I have tried:

tried to Decrease Heap size in management console.
Tried to upgrade and degrade service now Driver.