从文件中选择时的logparser额外参数(logparser extra argument when selecting from file)

从文件中选择时的logparser额外参数(logparser extra argument when selecting from file)

我有以下查询，我尝试进入CMD：

logparser "\"select URLUNESCAPE(EXTRACT_VALUE(SUBSTR(SUBSTR(Request, 0, INDEX_OF(Request, ' HTTP/')), ADD( INDEX_OF(Request, '?'),1) ), 'name')) as name into stagingtable from D:\\work\\FilesForLoading\\logfile.log"\" -i:ncsa -o:SQL -server:exampleServerName -database:exampleDbName -driver:\"SQL Server\" -e:100

但我得到了轰鸣声错误

错误：在查询后检测到额外参数“Server”“

我在这做错了什么？

我也这样试过：

logparser "select URLUNESCAPE(EXTRACT_VALUE(SUBSTR(SUBSTR(Request, 0, INDEX_OF(Request, ' HTTP/')), ADD( INDEX_OF(Request, '?'),1) ), 'name')) as name into stagingtable from D:\\work\\FilesForLoading\\logfile.log" -i:ncsa -o:SQL -server:exampleServerName -database:exampleDbName -driver:\"SQL Server\" -e:100

我犯了同样的错误。

I have the following query which i try to run into CMD :

logparser "\"select URLUNESCAPE(EXTRACT_VALUE(SUBSTR(SUBSTR(Request, 0, INDEX_OF(Request, ' HTTP/')), ADD( INDEX_OF(Request, '?'),1) ), 'name')) as name into stagingtable from D:\\work\\FilesForLoading\\logfile.log"\" -i:ncsa -o:SQL -server:exampleServerName -database:exampleDbName -driver:\"SQL Server\" -e:100

But I am getting the bellow error

Error: detected extra argument "Server"" after query

What am I doing wrong here?

I also tryied like this:

logparser "select URLUNESCAPE(EXTRACT_VALUE(SUBSTR(SUBSTR(Request, 0, INDEX_OF(Request, ' HTTP/')), ADD( INDEX_OF(Request, '?'),1) ), 'name')) as name into stagingtable from D:\\work\\FilesForLoading\\logfile.log" -i:ncsa -o:SQL -server:exampleServerName -database:exampleDbName -driver:\"SQL Server\" -e:100

I get the same error.

最满意答案

这是固定的。 正确的方法是使用-driver：“SQL Server”。 基本上它不会被\字符转义

It is fixed. The correct way is to use -driver:"SQL Server". Basically it is not escaped by the \ character