File Name Issue....

ravitell1 · Post by **ravitell1** » Mon Jan 31, 2011 2:03 pm

Hello All,

I have a situation where a file comes everyday with the name
"20101023000004_Sample_File" ....
File schedule for everyday
So the file name changes everyday... How to approach this issue...

Help appreciated...
Ravi.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 31, 2011 3:52 pm

Have the file land in a particular folder. In a sequence use a DIR /B command to get the file name and feed it to your job. Move the file to a different folder when done.

Shruthi · Post by **Shruthi** » Mon Jan 31, 2011 11:21 pm

One another option is File Pattern.

You can choose "Read Method" property to "File Pattern" and File name as "*_Sample_File"

But this can be used if any specific pattern there in file.

chulett · Post by **chulett** » Mon Jan 31, 2011 11:39 pm

Not in a Server job, I'm afraid.

koolsun85 · Post by **koolsun85** » Tue Feb 01, 2011 9:41 am

I think its better to go with a shell script.It gives you more flexibility.

chulett · Post by **chulett** » Tue Feb 01, 2011 10:34 am

If your scripting or command line skills leave something to be desired, another option is the Folder stage. It can return filenames based on a wildcard pattern if all you define is a single column in it.

ravitell1 · Post by **ravitell1** » Tue Feb 01, 2011 11:41 am

ray.wurlod wrote:Have the file land in a particular folder. In a sequence use a DIR /B command to get the file name and feed it to your job. Move the file to a different folder when done. ...

Thanks it worked...