Hi,
I want to dynamically create a qvd file name in the script, i.e. I want the qvd file name to be different each time it is created.
I'm using these script instructions that are not working, but I think I'm near to find the solution. Could any one provide ideas?
// Save all employees to QVD file.
// Saves headcount for the particular month.
SET vTableName = 'viewEmployee';
LET vMonthDay = Month(Today())&day(Today());
LET vFilename = $(vTableName)&$(vMonthDay);
$(vTableName):
LOAD id,
today() as EffectiveDate,
month(today());
SQL SELECT *
FROM "mydatabase".dbo.viewEmployee;
store * from $(vTableName) into $(vRoot)Extracts\$(vFilename).qvd;
drop table $(vTableName);
