Problem reading file name

paddu · Post by **paddu** » Fri Feb 22, 2008 5:48 pm

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

chulett · Post by **chulett** » Fri Feb 22, 2008 6:27 pm

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

paddu · Post by **paddu** » Fri Feb 22, 2008 6:56 pm

Thanks chulett.

I did not search efficiently . Will search the keywords

paddu · Post by **paddu** » Fri Feb 22, 2008 7:19 pm

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