none
Error in Connecting the Oracle Attunity Source in SSIS package

    Question

  • Hi ,

        May this question might have been posted before but as far as i am concerned i was not able to find the solution i am looking after , so please help me out on this . 

    I am using the Oracle Attunity Software to connect to the Oracle source and the Testing is also successful but during Run time the Attunity Oracle source is failing and the Error found was as shown below

    [Oracle Source [65]] Error: The AcquireConnection method call to the connection manager Oracle Connector 1 failed with error code 0x80004005.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    [SSIS.Pipeline] Error: Oracle Source failed validation and returned error code 0x80004005.
    [SSIS.Pipeline] Error: One or more component failed validation.
    Error: There were errors during task validation.

    Validation is completed

    [Connection manager "Oracle Connector 1"] Error: OCI error encountered. ORA-01005: null password given; logon denied
    Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

    I have tried the following solutions like changing the "Run64BitRuntime" to False also but its not working and i have even tried converting my package Protection Level with the "EncryptSensitiveWithPassword" but still of no use 

    Please help me out 

    Thanks & Regards,

    Santosh

        

    Wednesday, July 23, 2014 12:14 PM

Answers

All replies