SQL Loader in .Net

SQL Loader is used in order to bulk insert the data from the DataSet to Database in .Net and Oracle.

Since it is executed in the command prompt of the application path, it works faster and more securable. The point needs to remember is, the Database order columns and .dat file order columns should be same. Otherwise, the entire set of insertion is going to be cancelled while inserting.

sqlldr username/password

username - name of the schema database
password - password of the schema database
schemaname - name of the schema, which need to get insert using sql loader
control file name - control file which calls the data (.dat) file, which has the collection of records needs to be updated in the database

.Dat file is delimited with any specified character, for maintaining the data separation.

log file name - log file which is going to be created by run time, with the details of number of inserted records, rejected records, and reason for rejecting.