load data from oracle to SQL server using select...into

#1

I want to load data from oracle to SQL server using DTS and to use the select...into option so
the data will not generate entries in the transaction log

if I use the select...into it will not work since I need to connect to SQL server and because my source is oracle I can not
use this option .

note that I do not want to create a text file from oracle and use bulk load to load the data into SQL Server

10x in advance
ran

#2

Why bother with DTS if you want to use the SELECT INTO syntax?
Look at Linked Servers. They should do what you want here.
SELECT INTO will still use the transaction log

--

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

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

Quote:

I want to load data from oracle to SQL server using DTS and to use the
select...into option so
the data will not generate entries in the transaction log

if I use the select...into it will not work since I need to connect to SQL
server and because my source is oracle I can not
use this option .

note that I do not want to create a text file from oracle and use bulk
load to load the data into SQL Server

10x in advance
ran

#3

Sorry, not selling here - but I use Visual Integration Studio, it's
like DTS on steroids, check it out... http://www.crossrhoades.com

Joe

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

load data from oracle to SQL server using select...into

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

load data from oracle to SQL server using select...into - 12-08-2003 , 01:41 AM

Re: load data from oracle to SQL server using select...into - 12-08-2003 , 02:47 PM

Re: load data from oracle to SQL server using select...into - 12-28-2003 , 08:25 AM