Hi All, I have sql server 2008 with 32 bit. i want to access the oarcle data. i install olac(11.1.0). but when i am trying to made connection in ssis package it gives me error: test connection failed because of an error in initializing provider. unspecified error : E-fail:(0x80004005) please help me out. Thanks,

Hi punia, You have to re-install your OLAC?? driver in the server again. That will probably solve it. Hope that helps OnurBI and ERP Senior Consultant @ Nexum Bogazici If it is, Please dont forget to mark as answered or at least vote as helpful if the post helps you in any ways.

I have this same problem I have uninistalled and reinstalled multiple times. I have cleaned out the registry and reinstalled. I have tried it with and without the ORACLE_HOME environment variable. It works like a champ with SQL Developer. But it will not work within SSIS. Any assistance would be appreciated. I am running SQL 2008 on Windows 7.Ron