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@accenture.com> wrote in message
news:1d1a36fc.0310161121.3a042404@posting.google.c om...
> 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

Hmm - are the IBM client access drivers free?


"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:<O4Ue33ClDHA.2312@TK2MSFTNGP12.phx.gbl>...
> 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@accenture.com> wrote in message
> news:1d1a36fc.0310161121.3a042404@posting.google.c om...
> > 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