STORE Script Command using a variable for path

[tschullo]

Ok people, what am I doing wrong here?

LET vQVD_dir='..\QVD\debug\';
DIM_BUSINESS_LINE:
SQL

SELECT * FROM DIM_BUSINESS_LINE;
STORE DIM_BUSINESS_LINE INTO $(vQVD_dir)DIM_BUSINESS_LINE.QVD (QVD);
DROP TABLE DIM_BUSINESS_LINE;

Script blows up at STORE command.

My extractor is in the folder QV\EXTRACTORS

MY QVD folder is at QV\QVD

and I am trying to use a debug subdir QV\QVD\debug

What am I doing wrong? I've tried LET, SET,  no quotes, with quotes. 

Thanks,

Frustrated in NY

[swuehl · Accepted solution]

Does the debug folder already exist?

[tschullo]

Yes, it does

[sunny_talwar]

Script seems right to me. Is it giving you any specific error?

[VishalWaghole]

Please post which error you are getting at STORE.

[swuehl]

If you step into the script using the debugger, how does the expanded STORE command looks like?

Can you make it work using the hardcoded path?

[tschullo]

Sorry folks, my bad.

I was running script on server, created debug folder locally, thought I was in local copy.

[swuehl]

And just to double check: The user that runs the script has proper access rights to the folder and potentially already existing QVD and the potentially already existing QVD is not locked by another process?