Skip to content

extract-data-by-using-the-ole-db-source.md

Latest commit

 

History

History
68 lines (43 loc) · 3.46 KB

extract-data-by-using-the-ole-db-source.md

File metadata and controls

68 lines (43 loc) · 3.46 KB
title Extract Data by Using the OLE DB Source
description Extract Data by Using the OLE DB Source
author chugugrace
ms.author chugu
ms.date 03/01/2017
ms.service sql
ms.subservice integration-services
ms.topic how-to
helpviewer_keywords
extracting data [Integration Services]
sources [Integration Services], OLE DB
OLE DB source [Integration Services]

Extract Data by Using the OLE DB Source

[!INCLUDEsqlserver-ssis]

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

To extract data using an OLE DB Source

  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 source to the design surface.

  4. Double-click the OLE DB source.

  5. In the OLE DB Source 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.

  6. Select the data access method:

    • Table or view Select a table or view in the database to which the OLE DB connection manager connects.

    • Table name or view name variable Select the user-defined variable that contains the name of a table or view in the database to which the OLE DB connection manager connects.

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

      [!NOTE]
      The command can include parameters. For more information, see Map Query Parameters to Variables in a Data Flow Component.

    • SQL command from variable Select the user-defined variable that contains the SQL command.

      [!NOTE]
      The variables must be defined in the scope of the same Data Flow task that contains the OLE DB source, or in the scope of the same package; additionally, the variable must have a string data type.

  7. To update the mapping between external and output columns, click Columns and select different columns in the External Column list.

  8. Optionally, update the names of output columns by editing values in the Output Column list.

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

  10. You can click Preview to view up to 200 rows of the data extracted by the OLE DB source.

  11. Click OK.

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

See Also

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