I have an SSIS package that loops through a list of Oracle servers and performs some dataflow tasks. This works well and behaves nice when a DFT can't acquire a connection (I'm setting the server name property for the connection in a loop and have everything marked with delayed validation). I even have an OnError event handler built that will add the name of the Oracle server that was being accessed when the failure occured. What I want to know is how to access further error information from the connection manager in my OnError event handler. I really don't want to run a script that only acquires a connection and reports exception information in the catch block. Now, I know that SSIS captures this information because in the progress bar it's reporting exactly what I want.In the onError Event handler I get the following error information SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ORACLE" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. But the progress bar shows the following which is what I really want to capture [Connection manager "ORACLE"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "ORA-12545: Connect failed because target host or object does not exist ". Anyone have a clue on how I can get the OLEDB error information?

Hi,If you goto the event handler tab and enable it.You will find 2 system variables :ErrorCode & ErrorDescription.In the even handler you could configure a send mail task or a script task to notify using these 2 variables.I would also suggest to use the SourceName variable to now exactly in which place the error had occured.All these are system variables.Hope this helps !! - Sudeep | Please mark the post(s) as Answered that answers your query.

Sudeep,Thanks for responding but I'm using those system variables already and all they report is the DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER info from above. What I'm trying to do is find a part of the API I can call from the Script Task in my onError event handler to return the Connection Manager error information.Steve

HI try thishttp://dotnetslackers.com/articles/sql/UsingSQLServerIntegrationServicesSSIS.aspxand this http://blogs.conchango.com/jamiethomson/archive/2008/07/11/ssis-nugget-conditionally-email-a-file-containing-error-rows.aspxit will email you any error that has happendsincerelyShDont forget to mark the post(s) that answered your question, thanks

Nik3,Thanks for the reply. I'm very familiar with sending emails, the error handler and such. From the links you provided I don't see anything particularily relevent to the question I posed. I'm trying to acertain the root cause of the error information that is provided in the onError event handler.

Hi,Have you tried setting up the event handler for the OnInformation event.You get the variable ErrorDescription there also.you will get a lot of logging done in that case.May be you will get the error you require from here as all the things are being displayed by on information event.Hope this helps !! - Sudeep | Please mark the post(s) as Answered that answers your query.

Hi, I am getting the following error while executing the package Error at Package [Connection manager "SourceConnectionOLEDB"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "ORA-12545: Connect failed because target host or object does not exist I am running the package on Windows server 2008, 64bit, and i configured BI solution to run 32bit. Please help us in this issue. Thanks, Shreecanth