I am using Oracle Data Integrator to load a flat file into a remote db(oracle 10gR2) using SQLLDR. It fails with the following log.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach 
ORA-12170: TNS:Connect timeout occurred
However i tried to load the flat file using SQLLDR from the cmd prompt and it works fine. Can someone help me with this?
This is a connectivity issue, first check the sqlnet.log file. Next try to open a regular connection using sqlplus and see if it can be established.
Post the contents of the sqlnet.log and other related log files from the time the error pops up.