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 a process, because I have over then 30 stored procedures where I can replace xp_cmdshell call with my CRL procedure call.
I saw somewhere that I can use any kind of commands in a process call. (del.exe, bcp.exe, mkdir.exe, and also unmanaged code like third party executable files). My problem is that when I try to use bcp with arguments described above, nothing happens. If I use xp_cmdshell the import is running well.
If you can see, I use also a redirection to an error file, if something goes wrong, but even this file is empty. No error messages on execution, it seems that all goes well, but nothing is imported from my cvs file.
Is something wromg with use processes in this way ?
Or the problme is argument parameter ?
Or I can use somewhere in this argument an escape ?