Skip to content

Latest commit

 

History

History
51 lines (30 loc) · 2.7 KB

lesson-1-3-adding-and-configuring-an-ole-db-connection-manager.md

File metadata and controls

51 lines (30 loc) · 2.7 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic
Step 3: Add and configure an OLE DB connection manager
Lesson 1-3: Add and configure an OLE DB connection manager
chugugrace
chugu
01/03/2019
sql
integration-services
tutorial

Lesson 1-3: Add and configure an OLE DB connection manager

[!INCLUDEsqlserver-ssis]

After you add a Flat File connection manager to connect to the data source, you add an OLE DB connection manager to connect to the data destination. An OLE DB connection manager enables a package to extract data from or load data into any OLE DB-compliant data source. Using an OLE DB connection manager, you can specify the server, the authentication method, and the default database for the connection.

In this task, you create an OLE DB connection manager that uses Windows Authentication to connect to the local instance of [!INCLUDE sssampledbdwobject-md]. This OLE DB connection manager is also referenced by other components that you create later in this tutorial, such as the Lookup transformation and the OLE DB destination.

Add and configure an OLE DB connection manager

  1. In the Solution Explorer pane, right-click on Connection Managers and select New Connection Manager.

  2. In the Add SSIS Connection Manager dialog, select OLEDB, then select Add.

  3. In the Configure OLE DB Connection Manager dialog box, select New.

  4. For Server name, enter localhost.

    When you specify localhost as the server name, the connection manager connects to the default instance of [!INCLUDEssNoVersion] on the local computer. To use a remote instance of [!INCLUDEssNoVersion], replace localhost with the name of the server to which you want to connect.

  5. In the Log on to the server group, verify that Use Windows Authentication is selected.

  6. In the Connect to a database group, in the Select or enter a database name box, type or select [!INCLUDE sssampledbdwobject-md].

  7. Select Test Connection to verify that the connection settings you have specified are valid.

  8. Select OK.

  9. Select OK.

  10. In the Connection Managers pane, verify that localhost.AdventureWorksDW2022 is selected.

Go to next task

Step 4: Add a Data Flow task to the package

See also

OLE DB connection manager