Hi,
i want to parameterise the filenames in the SCd stage where, for surrogate key generation a flat file is used and the source name is set to the name of the file using which this key is generated.
I used a ENV variable for filename and there was a compilattion error. But when using a job parameter the job executed without problem.
In the job, i have declared the env varible as #$FileName#='c:\filename' and job parameter as #FileName#='c:\filename'
Any help is appreciated.
Thanks in advance.
Regards,
Clarence.
Using Env variables in SCD stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Wed Aug 29, 2007 1:33 am
- Location: Bangalore
- Contact:
Using Env variables in SCD stage
Rudresh Eswarappa
-
- Participant
- Posts: 82
- Joined: Tue Jan 22, 2008 10:37 am
- Location: UK
-
- Participant
- Posts: 21
- Joined: Wed Aug 29, 2007 1:33 am
- Location: Bangalore
- Contact:
-
- Participant
- Posts: 82
- Joined: Tue Jan 22, 2008 10:37 am
- Location: UK
JR29536 is a patch to be applied to FP1(a), support should tell you this if you explain your issue, and also look for superceding patches.
You may still find areas of the SCD editor that do not support env. vars, in which case you would raise a support ticket, or use GetEnvironment("envvar") as a workaround, if that part of the editor supports it.
You may still find areas of the SCD editor that do not support env. vars, in which case you would raise a support ticket, or use GetEnvironment("envvar") as a workaround, if that part of the editor supports it.