topic Direct Discovery error in QlikView

Direct Discovery error

srik00001 — Thu, 26 Mar 2015 15:02:10 GMT

I am trying to test out direct discovery for a few scenarios we have and am running into an error. Can you help me out with the syntax

I am trying to load one table using direct discovery the encounter the below error

Error -- expected <ColumnClauses>, found "

DIMENSION

[Company ID]

,[CompanyName]

MEASURE

[Sales]

FROM [dbo].[Company]"

DIRECT QUERY

DIMENSION

[Company ID]

,[CompanyName]

MEASURE

[Sales]

FROM [dbo].[Company]

The load script i am using

//ODBC CONNECT TO DSN_MM;

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Metric_Master;Data Source=XXXXXX;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=XXXXXX;Use Encryption for Data=False;Tag with column collation when possible=False];

DIRECT QUERY

DIMENSION

[Company ID]

,[CompanyName]

MEASURE

[Sales]

FROM [dbo].[Company];