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

OM Katyarmal 0 Reputation points

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

    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:


    Zoe Hui

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

    0 comments No comments