SET @strbcpcmd = 'bcp "select * from ##tmpJsonTable" queryout "'+@path+'" -w -C OEM -t"$" -T -S'+@@servername
You should listen to Erland to print out your string command since you have a working non-variable version. You are missing two single quotes to connect your path variable in the string.
No comments:
Post a Comment