Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Where?
after the data has loaded and before the store?
are you able to fetch the data from data source??
Connection string used to fetch the tables from Database server....
Yes, the problem is storing it.
STORE SEGMENTS INTO 'lib://QVD_FOLDER/SEGMENT.qvd' (qvd);
Does this work?
No, hence the original question.
Sorted
STORE SEGMENTS INTO [lib://QVD_FOLDER (xxxxxx_e1111111)/SEGMENTS.qvd](qvd);
" (xxxxxx_e1111111)" needed to be addedd