I studied from net that when the "Direct = True" option is used then the insertion into the db table would be faster. so i tried. but when i don provide that option, then the details are exactly loaded into my db table.
Can anyone help me in pointing out the problem.
cCommand_line ='SQLLDR.EXE CONTROL = '+TEMPDIR+'CONTROL.CTL'+' '+;
+'LOG = '+TEMPDIR+'S2K.LOG USERID ='+lcUserName+'/'+lcPassWord +'@'+;
lcDatasource + ' ROWS=1000 Direct = True '