Hi,
I want to pass source system as part of the file name. I've defined a job parameter called 'SOURCE_SYSTEM' and assigned value 'TEST'. Then I've entered the following value for File parameter in sequential file stage.
File=H:\Project\Work\#SOURCE_SYSTEM#_MASTER.txt
I can view data without any issues. But when I execute the job it's throwing the following error
Unable to open H:/Project/Work[&SOURCE_SYSTEM]_MASTER.txt: No such file or directory
Not sure why it didn't replace SOURCE_SYSTEM with parameter.
Any ideas???
Thanks
Parameter passing to sequential file stage
Moderators: chulett, rschirm, roy
Parameter passing to sequential file stage
Thanks,
Upul
Upul
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: