Page 1 of 1

Problem reading file name

Posted: Fri Feb 22, 2008 5:48 pm
by paddu
Filename i need to access has varying timestamp. I am trying to get filename at run time using pattern matching through command prompt.

My command in Execute command Stage is

dir ETLserverpath\R_test_Product* /B

Output from command ====>
R_test_Product_200802141522.csv


I am passing this value to job parameter as
File_Name:Execute_Command_1.$CommandOutput

I got following error .

Exception raised: @Job_Activity_0, Error calling DSSetParam(File_Name), code=-4 [ParamValue/Limitvalue is not appropriate]


What am i doing wrong???

Any suggestions appreciated
Thanks
Paddu

Posted: Fri Feb 22, 2008 6:27 pm
by chulett
What are you doing wrong? Not searching before posting. This has been discussed a bajillion times, please have a go at searching for a significant portion your error message, such as:

ParamValue/Limitvalue is not appropriate

Posted: Fri Feb 22, 2008 6:56 pm
by paddu
Thanks chulett.

I did not search efficiently . Will search the keywords

Posted: Fri Feb 22, 2008 7:19 pm
by paddu
Thanks it worked fine now .

I gave Field(Execute_Command_1.$CommandOutput,@FM,1) in job parameter and it worked .

Sorry for not doing thorough search at first step.

Thanks
Paddu