DSXchange

OK, I got it.
I'll try it tomorrow and will let you know.
Thanks for your help.

My bad..
I think I misunderstood the post too.
As suggested by Ray in that post, we can change the values defined in values files belonging to the Parameter Set, if "(As pre-defined)" is not set.
Sorry again for the inconvenience.

@Eric Thanks for your response. yes I am using file patterns, but can you tell me where I have to put this code ? Is it in the File Path in the Sequential File or in the Filter property. Because if its in the filter property then it wont work. And what #PATH1 and #PATH2 stands for according my examp...

Yes, You can override the values of parameters if you are passing the values through scripts.
And if you don't pass any value, then the default value will be picked up which is set in the job.
We are also doing the same in some of our jobs.

@Craig/BI-RMA
So my only solution is to use it through script or creating a sequence ??
I don't have any other solution, do I ?

With the restrictions you've posted, I think you are basically... what's the technical term... screwed Well thats another way to describe my position :) My client is a stubborn company :oops: , we dont have the flexibility to ask why, how, when etc.. We do it what we are asked to do. :( @BI-RMA/Cra...

We use UNIX/Perl scripts for scheduling of jobs. Those scripts pass the parameters to the jobs at run time. These scripts are generic in nature i.e. I cant change the script to as to accommodate 1 more parameter. This particular job run in Production but due to some client policy, the client is now ...

jerome_rajan wrote:2. In Job: Write your file into the temp folder created

How ?
How can I write the files when I cant even read them ?
As told above, daily new date folders will be created so I need a parameter to read that folder.

OK, even if I can use another parameter but I cant create a sequence here.
Actually in our project we do not create sequences and thats the way we work.
Even if I create a sequence, my TL/client wont approve it.
So now tell me what options do I have ?

@BI-RMA
Thanks for your input, but we have a constraint at our end that we dont use sequences and secondly I can't use another parameter.
Cant there be something done using only BusinessDate parameter which I have mentioned earlier ?

Hi All, I have a small job where the source is a Sequential File. The path of the file will be /data/XXX/20130420/A.txt The path will contain a date folder(without hyphens) as shown above. The job will run daily and so the folder will also change according to the run date e.g 20130421, 20130422 etc....

A quick question..
Why do you need a sql file for simple query like Why not use the connector stage itself ?
There you can parametrize the date too.

Let me rephrase it
And our Client/Company(Managers) does not think what we developers think about this website

@Craig
Actually I get to see probably first two lines only.
From that I assumed what your post is
I know I have to renew my membership, but the money has to be approved by our client .
And our client does not think what we developers think about this website.

@Craig,
Cant view your whole response
Can you please summarize it ?