Re: DTS writing to Non SQL Server Target

#1

In article <3031B5EE-DBDF-4B1D-B334-59C2F20C2724 (AT) microsoft (DOT) com>, Danglet wrote:

Quote:

I want to use DTS to source data from various targets (Oracle, Ingres, Access, Flat Files) to build a staging area in SQL Server. Some of the data needs to be transferred/shared with a different Oracle database, though.

Can DTS write data directly to Oracle or would I have to export/dump the data and load it on the Oracle side with sql loader?

Thanks!

The choice is yours. Yes DTS can, providing you have the drivers, talk to Oracle. If you have ODBC drivers to it then the chances are DTS will talk to it.

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

#2

Oh yes. Amongst others I write to

Informix, Oracle, SQL Server, Excel, Access, Solid, Text File, dBase,
VFP etc etc

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

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

Re: DTS writing to Non SQL Server Target

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

Re: DTS writing to Non SQL Server Target - 07-08-2004 , 10:51 AM

Re: DTS writing to Non SQL Server Target - 07-08-2004 , 11:51 AM