HOW TO: Add the Microsoft SSIS Oracle and Teradata components to the VS 2008 Toolbox

[Adeeb Mass'ad]

How to add the Microsoft SSIS Oracle and Teradata components to the VS 2008 Toolbox?

SUMMARY

After completing a successful installation of the Microsoft SSIS Oracle or Teradata Connectors, the user should add the components to the Visual Studio 2008 toolbox.

MORE INFORMATION

The Intelligence Development Studio (or Visual Studio) enables you to customize and add the components you need during your project development.

The installation of the Microsoft SSIS Connectors for Oracle and Teradata do not add the components to the default Toolbox.

Add the components as follows

1. Source Components

1.1. Right-Click on the Data Flow Sources pane of the Toolbox and click on Choose Items.

5.png

1.2. Click on the SSIS Data Flow Items tab.

• For Oracle locate the Oracle Source component, and enable the checkbox.

6.png

• For Teradata locate the Teradata Source component, and enable the checkbox..

1.3. Click OK.

2. Destination Components

2.1. Right-Click on the Data Flow Destinations pane of the Toolbox and click on Choose Items.

2.2. Click on the SSIS Data Flow Items tab.

• For Oracle locate the Oracle Destination component, and enable the checkbox.

• For Teradata locate the Teradata Destination component, and enable the checkbox.

7.png

2.3. Click OK.

APPLIES TO

• Microsoft SQL Server Business Intelligence Development Studio 2008.
• Microsoft SSIS Connector for Oracle by Attunity
• Microsoft SSIS Connector for Oracle by Attunity - Itanium IA64
• Microsoft SSIS Connector for Oracle by Attunity X64
• Microsoft SSIS Connector for Teradata by Attunity
• Microsoft SSIS Connector for Teradata by Attunity X64