Not sure if this was done on your side, but you need to install 32 bit oracle client. Check out the links below:

http://msdn.microsoft.com/en-us/library/ee470675.aspx

http://www.attunity.com/forums/microsoft-ssis-oracle-connector/error-failed-load-oci-dll-1308.html