DSXchange

I have a file listed in the Dependencies of Job properties.
Assuming I have a value in the file that I want to use in transformer stage. How do I achieve that?

Your question is not clear. What do you want to do - record the file as being something on which the job depends (in the Dependencies tab), or to use the file somehow in a Transformer stage?

Please describe with much greater clarity what you are proposing or desiring to do.