Hello,
I'm encountering an error when trying to load data and store into QVD files from two separate databases.
In the load script I've got two tabs with the DB connection string and then the following syntax:
JournalsDB1:
LOAD
Column 1,
Column 2,
Column 3,
Column 4,
Column 5,
Column 6,
Column 7;
SQL SELECT *
FROM DB1.dbo.vwDBJournal;
STORE JournalsDB1 INTO QVDs\JournalsDB1.qvd (qvd);
and then in the second tab -
JournalsDB2:
LOAD
Column 1,
Column 2,
Column 3,
Column 4,
Column 5,
Column 6,
Column 7;
SQL SELECT *
FROM DB2.dbo.vwDBJournal;
STORE JournalsDB2 INTO QVDs\JournalsDB2.qvd (qvd);
The script loads and stores the data fine for the first tab but then for the second tab, it doesn't work and states 'Table not found' which is strange as when trying this separately for the second database, it loads the data and stores it without any issues.
I've managed to work around it by concatenating the data from both databases in one tab but I've used the above method in the past, so I'm wondering why it might be failing now.
Any suggestions or help would be appreciated.
Many thanks
