Skip to content

azure-subscription-connection-manager.md

Latest commit

 

History

History
39 lines (26 loc) · 2.36 KB

azure-subscription-connection-manager.md

File metadata and controls

39 lines (26 loc) · 2.36 KB
title Azure Subscription Connection Manager
description Azure Subscription Connection Manager
author chugugrace
ms.author chugu
ms.date 03/02/2017
ms.service sql
ms.subservice integration-services
ms.topic how-to
f1_keywords
sql13.dts.designer.afpsubscrconn.f1
sql14.dts.designer.afpsubscrconn.f1
ms.custom sfi-image-nochange

Azure Subscription Connection Manager

[!INCLUDEsqlserver-ssis]

The Azure Subscription connection manager enables an SSIS package to connect to an Azure subscription by using the values you specify for the properties: Azure Subscription ID and Management Certificate.

The Azure Subscription connection manager is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure.

  1. In the Add SSIS Connection Manager dialog box shown previously, you select Azure Subscription, and click Add. You should see the following Azure Subscription Connection Manager Editor dialog box.

    Screenshot showing the Azure Subscription Connection Manager Editor dialog box.

  2. Enter your Azure subscription ID, which uniquely identifies an Azure subscription, for the Azure subscription ID. The value can be found on the Azure Management Portal under Settings:

  3. Choose Management certificate store location and Management certificate store name from the drop-down lists.

  4. Enter Management certificate thumbprint or click the Browse... to choose a certificate from the selected store. The certificate must be uploaded as a management certificate for the subscription. To do so, click Upload on the following page of the Azure portal (see this MSDN post for more detail).

    Screenshot of the Azure Management Portal showing the MANAGEMENT CERTIFICATES tab of the Settings page.

  5. Click Test Connection to test the connection.

  6. Click OK to close the dialog box.