Need for help

[#1]

I would like to perfom a parsing of the a set of SDN ODBC connection.

So I defined SDN ODBC as From_source_A, From_Source_B,....From_Sour_B. Each datasource has the same DDL.

The aim is to parse this set of SDN ODBC and perfom the smae loading script.

Have you an idea ?

Best regards

Sire

[yblake]

try

for each dsn in 'dsn1','dsn2','dsn3'

connect '$(dsn)';

....

disconnect;

next dsn;

[#3]

But it as me password for each step.

How can avoid this

best regrads

[disqr_rm]

One option to use OLEDB instead of ODBC. The OLEDB Connection string can save the encrypted password.

[Anonymous]

Can't your DSNs be configured with login/passwprd, if the security requirements permits?