Hi,

I am investigating the possibility of doing a nightly copy of a couple
of tables from SQL Server 2000 to DB2 using DTS. I know that it is
possible to do this, the question is what do I need to make this
export to DB2 work in terms of software? I think Windows has its own
built in DB2 driver, but in the past I have used DB2
Connect/ShadowDirect drivers for establishing communications between a
windows box and a DB2 database.

Do I need anything additional to establish communications between SQL
Server and DB2? Is there any robust driver/software package that is
recommended to do this kind of nightly transfer?

Thanks,
Fiaz

I use IBM Client Access Drivers.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"FS" <fiaz.sindhu (AT) accenture (DOT) com> wrote

Hmm - are the IBM client access drivers free?


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote