This code retrieves currency exchange data from the Bank of Canada API. Read the slides for details on the configuration of the SSIS script component.
Consume any REST API and load the response to database. You don’t need to load all the response fields, 3 or 4 is okay for me. Implement SCD type 6 for the “EMPLOYEE_Q2” table: Notes: 2.1. The SCD ...