Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayDestination Assistant
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
The Destination Assistant component helps create a destination component and connection manager. The component is located in the Favorites section of the SSIS Toolbox.
Note
Destination Assistant replaces the Integration Services Connections project and the corresponding wizard.
This topic provides steps to add a new destination using the Destination Assistant and also lists the options that are available on the Add New Destination dialog, which you will see when you drag-drop the Destination Assistant to the SSIS Designer.
In SQL Server Data Tools (SSDT), open the Integration Services package that you want to add a destination component to.
Drag the Destination Assistant component from the SSIS Toolbox to the Data Flow tab. You should see the Add New Destination dialog box. The next section provides you details about the options available in the dialog box.
Select the type of the destination in the Types list.
Select an existing connection manager in the Connection Managers list or select <New> to create a new connection manager.
If you select an existing connection manager, click OK to close the Add New Destination dialog box. You should see the destination and connection managers added to the data flow.
If you click <New> to create a new connection manager, you should see a Connection Manager dialog box, which lets you specify parameters for the connection. After you are done with creating the new connection manager, you will see the destination and the connection manager in SSIS Designer.
The following table lists the options available on the Add New Destination dialog box.
| Option | Description |
|---|---|
| Types | Select the type of destination you want to connect to. |
| Connection Managers | Select an existing connection manager or click <New> to create a new connection manager. |
| Show installed only | Specify whether to view only installed destinations. |
| OK | Click to save your changes and open any subsequent dialog boxes to configure additional options. |
Additional resources
Training
Module
Introduction to Azure Data Factory - Training
Evaluate whether Azure Data Factory can help you integrate your data sources. Describe how Azure Data Factory can ingest data from on-premises, multicloud, and SaaS data sources.
Certification
Microsoft Certified: Azure Data Engineer Associate - Certifications
Demonstrate understanding of common data engineering tasks to implement and manage data engineering workloads on Microsoft Azure, using a number of Azure services.