To create a connection to Oracle, do the following:

1. Right-click in the Connection Managers pane and select New Connection from the context menu. The Add SSIS Connection Manager dialog box is displayed:

   

2. In the Connection manager type list select DevartOracle and click Add. The General tab of the Oracle Connection Manager Editor dialog box is displayed:

   

3. Specify the connection parameters.

   1. If you connect through OCI, in the Server property type TNS alias of the server.
   2. If you use Direct mode, perform the following assignments:
      • set Direct to true
      • in the Server property type DNS name or IP address of the computer where Oracle server resides
      • in the Sid property type service name
      • In the Port property specify the port that the server listens to (usually this is 1521).

   In our tutorial we create a Direct mode connection that does not require Oracle Client.