Hi @swamy udayagiri ,
Please check if you have full permissions to access to SAP Odata source;
Please check if you set the user name and password correctly.
Hope the following links will be helpful:
1.2804524 - Error: "401 Unauthorized" OData Authentication Fails in First Attempt
2.SSIS - SAP Business ByDesign Odata Source
3.Using the OData Source in SQL Server Integration Services
Best Regards,
Mona
----------
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.