parameter name --> Password
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
parameter name --> Password
All,
I have designed more than 75 jobs so far. ODBC stage has been used in most of the jobs.
In 'Password' box --> I have hard coded the password, say for example if the password is 'karthik' then i just hardcoded it as ******.
I know it is not the correct way if we want to change the username and password at runtime.
I have created a ParameterSet and declared a variable called SourcePWD and then given the password (ex: karthik)
now my question is
shall i give #SourcePWD# in the 'password' textbox (say for example ********** --> #SourcePWD#) instead of hardcoding the password?
I have designed more than 75 jobs so far. ODBC stage has been used in most of the jobs.
In 'Password' box --> I have hard coded the password, say for example if the password is 'karthik' then i just hardcoded it as ******.
I know it is not the correct way if we want to change the username and password at runtime.
I have created a ParameterSet and declared a variable called SourcePWD and then given the password (ex: karthik)
now my question is
shall i give #SourcePWD# in the 'password' textbox (say for example ********** --> #SourcePWD#) instead of hardcoding the password?
Karthik
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
i have some questions on 'Parameter Set' ?natashab wrote:Yes,you can use the parameter
I see 3 tabs when i open a parameter set.
1) General
2) Paramaters
3) Values
what is the difference betewen 'Parameters' and 'Values' ? I see i can enter values in both the tabs. which one will be taken at run time?
if i use parametr set in my job, do i need to specify the paramter set name in the .ini file ? Because i faced some issues when i run a batch.
I have created a parameter.ini file and specified the values in the file. say for example,
Content of parameter.ini file
SourceDSN = MF_QA
But in the parameter set, i gave MF_DEV.
when i run the batch (which call the parameter.ini file to populate values for the variables), it took MF_DEV instead of MF_QA.
then i changed like
Content of parameter.ini file
<parameter_set_name>.SourceDSN = MF_QA
after this change, the batch job took MF_QA.
why?
Karthik
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm