TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Datta Kharad
NA
1.6k
53.4k
Call SQL Loader from C# application?
Feb 24 2012 9:17 AM
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.
Reply
Answers (
2
)
How to update in database
Null exception