User-73514677 posted
HI.
I have a C# applicaitotn, in which I want to use the SQL BCP utility. I have been able to run a single command and the data is extracted, but I want to make it as a function, which can be run for multiple queries.
All the SQL statements are in resx file. I am able to iterate through the data in resx file, but not sure how to pass it to the BCP process?
I have my current code as below:
processCMD("bcp",
String.Format("\"select 'COUNTRY', 'MONTH' union all SELECT COUNTRY, cast(MONTH as varchar(2)) FROM DBName.dbo.TableName\" queryout {0}FILE_NAME.csv -c -t; -T -{1}", ExportDirectory, SQLServer));
static void processCMD(string fileName, string arguments)
{
System.Diagnostics.Process proc = new System.Diagnostics.Process();
proc.StartInfo.FileName = fileName;
proc.StartInfo.Arguments = arguments;
proc.Start();
proc.WaitForExit();
}
Is the above the right way to use BCP?
Each query should save in different file.
Thanks