How to load a Currency Exchange rate data using a real time currency conversion API in SSIS

OM Katyarmal 0 Reputation points
2023-04-11T04:52:39.41+00:00

I want to load Currency Exchange data into SSIS (SQL SERVER INTEGRATION SERVICES) With built-in function. Can you help me?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,866 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,386 Reputation points
    2023-04-11T06:12:12.6166667+00:00

    Hi @OM Katyarmal Check it out here to see if it is helpful.

    Calling a Restful API in SSIS and returning output

    You may also consider to use OLE Automation Stored Procedures.

    refer article: https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/ole-automation-stored-procedures-transact-sql?view=sql-server-ver16.

    Regards´╝î

    Zoe Hui


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

    0 comments No comments