Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Store QVD in folder

Hi Guys,

What's the correct syntax for storing qvd's?

The folder i've created on the right in Data Editor is called QVD_FOLDER the actual folder on the server is called QVD, what am i doing wrong in the store syntax.

Thanks Guys

LIB CONNECT TO 'XXX.HOST.NAME.com (user_e111)';

SEGMENTS:

load *;

sql select *

FROM Warehouse.dbo."SEGMENT";

STORE SEGMENTS INTO [lib://QVD_FOLDER/SEGMENT.qvd](qvd);  // with folder created in Data Editor name QVD_FOLDER

or

STORE SEGMENTS INTO [lib://QVD/SEGMENT.qvd](qvd);  // with server folder name QVD

15 Replies
Anonymous
Not applicable
Author

Where?

after the data has loaded and before the store?

Anonymous
Not applicable
Author

are you able to fetch the data from data source??

Connection string used to fetch the tables from Database server....

Anonymous
Not applicable
Author

Yes, the problem is storing it.

Anonymous
Not applicable
Author

STORE SEGMENTS INTO 'lib://QVD_FOLDER/SEGMENT.qvd' (qvd);

Does this work?

Anonymous
Not applicable
Author

No, hence the original question.

Anonymous
Not applicable
Author

Sorted

STORE SEGMENTS INTO [lib://QVD_FOLDER (xxxxxx_e1111111)/SEGMENTS.qvd](qvd);

" (xxxxxx_e1111111)" needed to be addedd