Hi
I want to call SQL Loader from c# application, I did it Incomplete. Suppose I have 80000 rows in a table. After call SQL loader from my application, only 12000 rows are inserted into table or sometime 15000 and its take long time for this process.
My Code:-
Process proc = new Process();
string myCommand = @"CMD.EXE";
proc.StartInfo = new ProcessStartInfo(myCommand);
//Set up arguments for CMD.EXE
proc.StartInfo.Arguments = @"/c SQLLDR user/pwd@oracle CONTROL=D:\ContolFile.CTL";
proc.StartInfo.RedirectStandardOutput = true;
proc.StartInfo.RedirectStandardError = true;
proc.StartInfo.UseShellExecute = false;
proc.StartInfo.WorkingDirectory = @"D:\";
proc.Start();
proc.WaitForExit();
proc.Close();
if (proc.ExitCode == 0)
{
MessageBox.Show("Successfully Inserted");
}
else
{
MessageBox.Show(proc.StandardError.ReadToEnd());
}
If I will do this manually using Command Line prompt then It will insert 80000 rows in a table. But I want do this in C# application. Please give me appropriate solution.
Loading

Vir WPosted Apr 29, 2013, 3:17 AM
Datta KharadPosted Mar 2, 2012, 4:51 AM
http://www.dotnetheaven.com/Forums/Thread/162723/error-occurred-while-calling-sql-loader-from-C-Sharp-windows-app.aspx