DSXchange

Hello Every one,

I am trying to pass paramter while run time. The parameter will be the csv file in Sequential Stage. In the Sequential stage, in output tab, i am giving file name as #file1#. In the Job properties window, in the parameters tab,
parameter name = filename,
prompt = enter file
Type=string
Default Value=null
when i click on view data,
its giving Failed to open #file1# Status=-1 error.

Please help me ,

Thanks,
Bram

Unless I'm missing something here, you've named your parameter filename. That means that in the sequential file stage, you need to reference #filename# - not #file1# - in order to use this job parameter.

A big clue that things are ok or not setup properly is, when you click 'View Data', does it prompt you for the appropriate number of parameters before it tries to fetch the data? If the answer is 'no' then you need to check the spelling of the parameter names you are using - and they are case sensitive, btw - and correct whatever is wrong.

Thank You Craig Hulett ,

for your prompt reply and your solution,

You are the man!!!!!!!

Thanks again