Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to do a simple store to an existing QVD, but am getting a "general Script Error".
Here is the script:
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
Lockbox2:
LOAD DATE,
DIFFERENCE,
[Reconcilation Time],
maxdate
FROM
[..\Data\Close Improvement\Dashbaord\MEC Snapshot\Data\Bank_Lockbox2.xlsx]
(ooxml, embedded labels, table is [Sheet1 (2)]);
Store Lockbox2 INTO
Logfile Error:
STORE Lockbox INTO [E:\Data\Close Improvement\Dashbaord\MEC Snapshot\QVD\Lockbox.QVD
General Script Error
Execution Failed
Execution finished.
try.
SET vPath='E:\Data\Close Improvement\Dashbaord\MEC Snapshot\QVD\'
Lockbox2:
LOAD DATE,
DIFFERENCE,
[Reconcilation Time],
maxdate
FROM
[..\Data\Close Improvement\Dashbaord\MEC Snapshot\Data\Bank_Lockbox2.xlsx]
(ooxml, embedded labels, table is [Sheet1 (2)]);
STORE * FROM Lockbox2 INTO $(vPath)Lockbox.QVD;
Drop table Lockbox2;