.....is done best how ?

Have heard of Toad...or perhaps linked server and then use query analyzer ?
But this way I cannot get a list of tables on the Oracle database ?

And second (or third..) I need to have an Oracle client on the SQL Server
that needs to get data from Oracle ? Not just an odbc ?

Toad is an excellent choice
Yes you need the Oracle bits on the PC/Server that runs the DTS package

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

Would you consider text files instead of ole / odbc ?

It isn't that large record amount....

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

People have complained/noted in the past that Oracle to SQL Server can be slow so some have used Text Files as an intermediary.
Both systems have fast ways of loading text files.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote