Post reply

Dynamic Oracle Connection with SSIS

  • April 27, 2009 at 12:16 pm

    #203435

    Hello All,

    I have an SSIS package sourcing Oracle database. I could connect with no issues when I give the connection details directly, however, I have connection issues when trying to make dynamic connection using Connection String expression. Could anyone let me know how can I make dynamic connection with Oracle source.

    Following is the value defined in Connection String variable

    Data Source=SERVICE NAME;User ID=Oracle Username;Provider=MSDAORA.1;Persist Security Info=True;

    Following is the error I'm seeing when trying to make it a dynamic connection.

    Error at BDSOrganicCustomer [Connection manager "SERVICENAME.USERNAME"]: An OLE DB error has occurred. Error code: 0x80040E4D.

    An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E4D Description: "ORA-01017: invalid username/password; logon denied

    ".

    Error at Data Flow Task [OLE DB Source [1]]: The AcquireConnection method call to the connection manager "SERVICENAME.USERNAME" failed with error code 0xC0202009.

    (Microsoft Visual Studio)

    Thanks in advance,

    -Amith Vemuganti

  • April 27, 2009 at 8:28 pm

    #984809

    Amith Vemuganti (4/27/2009)

    Hello All,

    I have an SSIS package sourcing Oracle database. I could connect with no issues when I give the connection details directly, however, I have connection issues when trying to make dynamic connection using Connection String expression. Could anyone let me know how can I make dynamic connection with Oracle source.

    Following is the value defined in Connection String variable

    Data Source=SERVICE NAME;User ID=Oracle Username;Provider=MSDAORA.1;Persist Security Info=True;

    Following is the error I'm seeing when trying to make it a dynamic connection.

    Error at BDSOrganicCustomer [Connection manager "SERVICENAME.USERNAME"]: An OLE DB error has occurred. Error code: 0x80040E4D.

    An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E4D Description: "ORA-01017: invalid username/password; logon denied

    ".

    Error at Data Flow Task [OLE DB Source [1]]: The AcquireConnection method call to the connection manager "SERVICENAME.USERNAME" failed with error code 0xC0202009.

    (Microsoft Visual Studio)

    Thanks in advance,

    -Amith Vemuganti

    Amith,

    I don't see password parameter in your connection string.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • April 28, 2009 at 8:15 am

    #985125

    True. It worked after adding Password parameter. Thanks!

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

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