Post reply

Acquire Connection error

  • January 15, 2009 at 1:43 pm

    #129473

    i have created a SSIS package where it creates a flatfile from the database.(oracle)

    i created a config file where i pass the connection string of Database and location of the flat file folder.

    i get the below error

    ==========================

    Error: The AcquireConnection method call to the connection manager "connection1" failed with error code 0xC0202009.

    [Connection manager "connection1"] Error: 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 ".

    ===============================

    please let me know if any suggestion.

  • January 15, 2009 at 3:01 pm

    #927747

    Have you double-checked that you passed the correct credentials?

  • January 15, 2009 at 6:25 pm

    #927820

    Since it is not windows authentication i got to pass the userid and pwd inside the package.

    i tried to use save password option also.

    When i try to create a XML Config file, user id is carried forward but not the password

  • January 16, 2009 at 7:05 am

    #928083

    keywestfl9 (1/15/2009)

    Since it is not windows authentication i got to pass the userid and pwd inside the package.

    i tried to use save password option also.

    When i try to create a XML Config file, user id is carried forward but not the password

    Have you tried specifying the complete ConnectionString property (with the password in it)?

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

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

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