Skip to content

load-data-by-using-the-ole-db-destination.md

Latest commit

 

History

History
65 lines (41 loc) · 3.39 KB

load-data-by-using-the-ole-db-destination.md

File metadata and controls

65 lines (41 loc) · 3.39 KB
title Load Data by Using the OLE DB Destination
description Load Data by Using the OLE DB Destination
author chugugrace
ms.author chugu
ms.date 03/01/2017
ms.service sql
ms.subservice integration-services
ms.topic how-to
helpviewer_keywords
loading data
OLE DB destination [Integration Services]
destinations [Integration Services], OLE DB

Load Data by Using the OLE DB Destination

[!INCLUDEsqlserver-ssis]

To add and configure an OLE DB destination, the package must already include at least one Data Flow task and a source.

To load data using an OLE DB destination

  1. In [!INCLUDEssBIDevStudioFull], open the [!INCLUDEssISnoversion] project that contains the package you want.

  2. In Solution Explorer, double-click the package to open it.

  3. Click the Data Flow tab, and then, from the Toolbox, drag the OLE DB destination to the design surface.

  4. Connect the OLE DB destination to the data flow by dragging a connector from a data source or a previous transformation to the destination.

  5. Double-click the OLE DB destination.

  6. In the OLE DB Destination Editor dialog box, on the Connection Manager page, select an existing OLE DB connection manager or click New to create a new connection manager. For more information, see OLE DB Connection Manager.

  7. Select the data access method:

    • Table or view Select a table or view in the database that contains the data.

    • Table or view - fast load Select a table or view in the database that contains the data, and then set the fast-load options: Keep identity, Keep null, Table lock, Check constraint, Rows per batch, or Maximum insert commit size.

    • Table name or view name variable Select the user-defined variable that contains the name of a table or view in the database.

    • Table name or view name variable fast load Select the user-defined variable that contains the name of a table or view in the database that contains the data, and then set the fast-load options.

    • SQL command Type a SQL command or click Build Query to write a SQL command by using the Query Builder.

  8. Click Mappings and then map columns from the Available Input Columns list to columns in the Available Destination Columns list by dragging columns from one list to another.

    [!NOTE]
    The OLE DB destination automatically maps same-named columns.

  9. To configure the error output, click Error Output. For more information, see Debugging Data Flow.

  10. Click OK.

  11. To save the updated package, click Save Selected Items on the File menu.

See Also

OLE DB Destination
Integration Services Transformations
Integration Services Paths
Data Flow Task