Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle feature like DTS?

Oracle feature like DTS?

From: Aragon, Gabriel (GE Commercial Finance) <gabriel.aragon_at_ge.com>
Date: Wed, 3 Nov 2004 12:17:47 -0500
Message-ID: <DA3854DCCE41EA42B603E39691388AC31F442354@CINMLVEM05.e2k.ad.ge.com>


Hi guys,=20

this is a question from one of my programmers, you know in SQL server = there is this feature called DTS (Data Transformation Services) I have a = basic knowledge of this tool and use it only to export/import data = through Oracle/SQL and data movement in SQL, but I know it is capable to = do other things.

The scenary is like this:

  1. Pull a file from FTP
  2. Load it into a table
  3. Load another table directly from a database
  4. Process data and do some inserts into local DB tables

My first thought was to use unix scripts for the FTP stuff and maybe a = proc that use an external table to load and process data, and finally = crontab the entire operation, but (unfortunately) we are running under = win2k.=20

Question: Is there anything similiar to DTS in Oracle to "pack" all the = steps?=20

Comments are welcome.=20
TIA. Gabriel=20

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 03 2004 - 11:13:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US