Ram,

You should install Oracle Client on your development machine (similar to SQL Native Client installation). One thing to remember is that Oracle Client installation creates system variables and sometimes skips an important BIN folder. Without BIN folder SSIS/SQL Server can't find essential Oracle drivers/DLLs.

Good luck,

Steve.