ERROR [42000] Incorrect syntax near '*'

[Silvio]

Hello everybody,

I'm trying to extract data from MS SQL Server with data editor and following script:

LOAD *;
[DE01_SFA1_CarrierUsage]:
SELECT*
FROM DataMart.dbo."DE01_SFA1_CarrierUsage"

STORE * FROM [DE01_SFA1_CarrierUsage] INTO $(v10_DatenExtraktion)/$(vFolder)/DE01_SFA1_CarrierUsage.QVD;

Error message is:

ScriptErrorDetails: ERROR [42000] Incorrect syntax near '*'.,

ScriptErrorList: Files has wrong format

Debugger has red marked the underlined line above.

Previous data extraction with following script works - I do not understand the problem.

LOAD *;
[DE01_SFA1_PseudoNIO_Transformed]:
SELECT*
FROM DataMart.dbo."DE01_SFA1_PseudoNIO_Transformed"

STORE * FROM [DE01_SFA1_PseudoNIO_Transformed] INTO $(v10_DatenExtraktion)/$(vFolder)/DE01_SFA1_PseudoNIO_Transformed.QVD;

Is there anybody who can support, thank you!

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[Oleg_Troyansky]

Hi,

I believe your SELECT statement is missing the closing semicolon. I'm surprised that the previous data extraction worked without the semicolon - it shouldn't work.

Also, I'd place the table name [DE01_SFA1_PseudoNIO_Transformed]: before the preceding load - if nothing else, for a good logical view. The preceding load that does no transformations at all, is redundant. You can safely remove the statement and declutter the view.

Cheers, 

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[marksouzacosta · Accepted solution]

Hi @Silvio,

Try the code below. My changes are in bold:

[DE01_SFA1_CarrierUsage]:
SELECT *
FROM DataMart.dbo."DE01_SFA1_CarrierUsage"
;

STORE [DE01_SFA1_CarrierUsage] INTO [$(v10_DatenExtraktion)/$(vFolder)/DE01_SFA1_CarrierUsage.QVD](qvd);

Note: you don't need that LOAD *; at the beginning of the code.

Regards,

Mark Costa

[Silvio]

Thank you Mark! It works now.

Regards,

Silvio