110,499
社区成员
发帖
与我相关
我的任务
分享
//BCP -- Bulk Insert
System.Diagnostics.Process bcpPrc = new System.Diagnostics.Process();
bcpPrc.StartInfo.FileName = "cmd.exe";
string bcloadingSource = string.Empty, bcploadingDB = string.Empty, bcploadingUser = string.Empty,bcploadingPassword = string.Empty;
string bcpArgments="";
bcpArgments = @"/C " + driverLetter + " && cd " + workingFolder + " && dir && bcp " + bcploadingDB + ".dbo.*** in " + bcpFileName + " -f ***.fmt -m -S" + bcloadingSource + " -U" + bcploadingUser + " -P" + bcploadingPassword + " && exit";
bcpPrc.StartInfo.Arguments = bcpArgments;
bcpPrc.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
bcpPrc.StartInfo.CreateNoWindow = true;
bcpPrc.StartInfo.UseShellExecute = false;
bcpPrc.StartInfo.RedirectStandardOutput = true;
//ready for starting BCP process
bcpPrc.Start();
bcpPrc.WaitForExit(900000); //set waiting time to 15 minutes
bcpPrc.Close();
Process pc=new Process();
pc.StartInfo.FileName="bcp.exe";
pc.StartInfo.Arguments="bcp \"Northwind.dbo.Orders\" out \"Orders.txt\" -c -q -U\"dboP\"go dba\"";
pc.Start();