DSXchange

Hi,
While promoting the jobs to production enviroment I realised that I have to change the user name and password in all the places ...... Same with the mail component.

Is there anyway I can store them at a single place and use that at moltiple places???

use parameters

could you tell me the details

Hello Devashish,

Can you please also tell us which all stages are you using? If you are using the ODBC stage, then you cannot parameterize it; you will just have to change the username and passwords for all the stages and recompile the jobs.

In case of routines, you can write the username and password in a file and can read it from there.

Thanks,
Siddharth

I am using ODBC

Hi -

Maybe I haven't understood what you ask -
but there are no problems in using parameters in the ODBC stage for
"Data Source Name", "User Name" and "Password" (and for tablename and in the where-clause).

It is completely standard eg. -
create the parameter eg. UserName
enter #UserName# as the name in "User Name"

You can do the same thing with password - except you cannot see what you enter since the keystrokes are converted to "*" - but it will work. Pretty easy to test - the parameters will appear when you click on "view data"

Regards
Peter

Thanks Peter.

Hi,
I noticed you mentioned mail server,
since the mail notification stage doesn't support parameters,
if you need them you can use the DSSendMail routine (or the tester routine) in order to get parameters.

FYI, in case you have no problem with fixed values you can use the tools>options in the designer to set default values for this stage, this means that every notification stage you place wouls have them.

IHTH