How to use x-api-key in SSIS connection manager

Prathima Alapati 6 Reputation points

we have rewritten our api's to use x-api-key now i need to use that API in my SSIS. But the http connection manager will allow only basic authentication how can this be achieved ?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,325 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,881 Reputation points

    Hi @Prathima Alapati ,

    SSIS (SQL Server Integration Service) is a data migration software which is used to extract, transform, and load the data. Apart from extracting and loading the data, SSIS can also call the API to perform a certain task. Let’s take a scenario where the failure emails are stored in the database, and it has to be initiated in the night. Now, the problem is, we don’t have any UI screen to initiate these failure emails. So, we usually go with SQL jobs which are configured to run the SSIS packages on a scheduled basis.

    Please refer to the following links:
    1.How To Consume Web API Through SSIS Package
    2.Example using Web Services with SQL Server Integration Services
    3.Download source file from website with SSIS

    Best regards,


    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.