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