Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
luzippu
Starting Member
23 Posts |
 Posted - 2006-03-29 : 03:54:53
|
| i am using sql server express edition.i need to import (or make copies) on a weekly/daily basis, of several oracle tables into a new adp database.what is the fastest option? some of these tables hold over 1m records.so ideally i would like to schedule a refresh or update job outside busy hours.I have heard of "linked servers" and "dts", but would like some experts advice before starting looking into this.many thanksluzippu |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-29 : 04:18:29
|
| I don't know if SQL express has DTS, or Integration Server as it is now called. I think your best bet is to use SQL BCP to bulk load Oracle data that you have spooled to a flat file. Check this site for information on how you can do this http://www.orafaq.com/faqloadr.htm#UNLOAD-ec |
 |
|
|
luzippu
Starting Member
23 Posts |
Posted - 2006-03-29 : 10:06:01
|
| thanks eyechart.interesting option.i'm trying to use the unloader as per your example by applying the code below (changing the underlined text to real names):set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool onspool c:\oradata.txtselect col1 || ',' || col2 || ',' || col3from tab1where col2 = 'XYZ';spool offhowever, on the file created i only get a copy of the above code rather than the actual data.can you see what i'm doing wrong?thanksluzippu |
|
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-03-29 : 10:21:00
|
| FYI.. SSIS is not available with SQL express.. |
|
|
|
|
|
|
import oracle tables using dts or other...