Our company bought a new AS/400.
I need change the data source from OLd to New AS/400.

But the DTS don't like it, if it change the host table or re-config the
existing ODBC.

The main problem is 2 as/400 have 2 different database name.

Does anyone have a good idea to overcome this problem?

What do you mean it doesn't like it?
Wht errors do you get?


"Kam" <Kam (AT) discussions (DOT) microsoft.com> wrote

If I change the Host file. the error was
"[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL] SQ0114-
Relational Database AAProduction not the same as current server AANewProd.

Is there any quick and easy way to re-define the Relational Database Name in
the DTS Package?

"Allan Mitchell" wrote:

Properties of pckage are changeable and the easiest way to do this is to
use disconnected Edit

Right Click on the whitespace in designer in your package and choose
Disconnected Edit

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com


"Kam" <Kam (AT) discussions (DOT) microsoft.com> wrote