I remove try-catch block :

proc.StartInfo.FileName = fileName;

proc.StartInfo.Arguments = arguments;

proc.Start();

proc.WaitForExit();

return 2;

Now, when I run my stored procedure, still doesn't import anything. I have no...

Regarding your question about why I use CLR for bcp.exe. I have to automate the usage of bcp, because I have 30 stored procedures where we use this. Till now...

Sorry, it's a txt file, not cvs.

As you can see

filename = 'bcp.exe'

arguments = 'cssprod.BankCardtrxGPEtemp in \\WYVSTDEVCSS01\ClearingReport\KM1700903.txt -c -S WYVSTDEVCSS01\CSS_SQL01 -r -T -C 1250 -e \\WYVSTDEVCSS01\ClearingReport\bcp.error -m 1000 >NUL'

and the...

Hi, again!

Sorry if I not formulated clear my problem. First, I am new in using CLR. I thought that it will be easily for me to call bcp utility in...

I set permission to UNSAFE on assembly. So, not have now execute permission problems. I have another stored procedure where I use another commands, not bcp, and there I haven't...

I'm still not 100 percent clear in this problem.

I verified that SQL Server runs under Local system account.

I publish my assembly with EXTERNAL ACCESS permission set and I tried to...

It's something which is not clear for me.

So, SQL server is running under Local system account, on an terminal server.

I use my domain account to log into the server, and...

We have several stored procedures. In these sp's we want to made some IO operations with bcp, osql or other utilities.

Example :

SET @ExecCommand ="SELECT * from...

SQL Servers run under Local System account.