Post reply

How can I create the OLE DB Connection in SSIS

  • February 1, 2010 at 1:49 pm

    #142140

    We successfully used the Oracle Provider for OLE DB to create a linked server in SQL Server. I assume that proves that The provider does work. However, I have no idea how to implement this connection for SSIS. Here are the parameters we used to create the linked server that I would like to use to create a connection in SSIS:

    Provider: Oracle Provider for OLE DB

    Product Name: Oracle

    Data Source:

    (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= anadev10)(Port= 1563))(CONNECT_DATA = (SID = devetl)))

    How can I create this connection in SSIS?

  • February 1, 2010 at 1:56 pm

    #1111938

    You can set up a connection manager object using the OLE DB data source provider for Oracle. You will use the attributes that you've shown to set up your connection string.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • February 1, 2010 at 2:09 pm

    #1111947

    I attempted to create a new Connection Manager with a Native OLE DB/Oracle Provider for OLE DB. I cannot edit the Provider box. I don't see a Product Name box. I put in the Data Source I already listed. I get an error when I try to test the connection.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply