How can I execute a Stored Procedure with parameters through BCP command.
I have the following BCP statement and does not work.
bcp "exec MyDB..Letter_UPDATE @UserName @JobNumber" in "'TEST','123456'" -SMyServer -UMyusername -PMyPassword
Stored Procedure name: Letter_UPDATE
Paramters :@UserName, @JobNumber
Passing Data : "TEST", "123456"
All my other BCP commands are working fine, this is the only SP which has parameters and it is killing me. I hope it is a simple solution.......