"Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in message news:OZsXzvZ0EHA.2788@TK2MSFTNGP15.phx.gbl...
> ....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 ?
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:u4y73#Z0EHA.1940@TK2MSFTNGP15.phx.gbl...
> 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@hotmail.com> wrote in message
news:OZsXzvZ0EHA.2788@TK2MSFTNGP15.phx.gbl...
> > ....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 ?
> >
> >
>
>

"Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in message news:uSvzHIa0EHA.3588@TK2MSFTNGP14.phx.gbl...
> Would you consider text files instead of ole / odbc ?
>
> It isn't that large record amount....
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:u4y73#Z0EHA.1940@TK2MSFTNGP15.phx.gbl...
>> 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@hotmail.com> wrote in message
> news:OZsXzvZ0EHA.2788@TK2MSFTNGP15.phx.gbl...
>> > ....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 ?
>> >
>> >
>>
>>
>
>