It took me 10 seconds of Googling to find the answer for the default code page warning (which is a warning, so it will not crash your package):
http://consultingblogs.emc.com/jamiethomson/archive/2005/10/25/SSIS_3A00_-Connect-to-Oracle.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP