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
Job Parameter error
Moderators: chulett, rschirm, roy
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers