Is it possible to use BCP In with named pipe in SQL Server 2008 R2? -

i have input json file want load sql server table. following below steps:

1) convert json file flat structure using jq utility. (http://stedolan.github.io/jq/)

2) store output of jq flat file

3) load flat file sql table using bcp

bcp database.schema.table in "\\shareddirectory\inputfilename.txt" -t -s "server" -w -t ~ -r \n 

is possible skip step 2) , load output of jq directly sql server table using bcp? trying run below command:

jqcommand | bcp database.schema.table in -t -s "server" -w -t ~ -r \n 

judging can see in msdn, seems bcp accepts files inputs.

for windows, there special file called con used capture stdin (similar /dev/stdin). try using that.

jqcommand | bcp database.schema.table in con -t -s "server" -w -t ~ -r \n