Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 600
  • Last Modified:

DTS to import data from Oracle tables

Hi all, does anybody could give me indications on how to do to build a DTS that imports data from a Oracle db to sql-server. The tables have the same schema.

Indications + code are welcome

tnx
0
NetDeveloper
Asked:
NetDeveloper
  • 3
  • 2
1 Solution
 
JardITCommented:
Create a DTS package. Drop a OLEDB for Oracle connection and a OLEDB for SQL connection on to the package. Click and select both connections and use the Transform data task to connect the Oracle OLEDB connection to SQL OleDB Connection. Right click on the Transform Data task and select the oracle table as source, next select the sql table as the destination. If both sql and oracle tables are the same, have the same names then the fields will be mapped automagically. If not the you will have to manual map the oracle fields to the sql fields. Then run the package.

see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/dts_overview.asp for over view of DTS
OR http://www.sqldts.com/default.aspx?278,4
0
 
NetDeveloperAuthor Commented:
Hi, where I find  OLEDB for Oracle connection  and OLEDB for SQL connection

and Transform data task

does I have to drop it too ?

tnx
0
 
NetDeveloperAuthor Commented:
...also...

so for data replication ... as this case there is no need to write a custon Active X
0
 
JardITCommented:
Create a new package by right clicking on the data transformation services folder and select NEW Package. When the package opens you should see two tool boxes in the top left hand corner of the screen. One titled Connections and one titled tasks. In connections you can use odbc for oracle the icon that is comprised of 2 databases or select the icon with the earth on it. In the opening window under connections drop down you should be able to choose oracle oledb . Then follow the steps entering in your connection sting. sql oledb Connection is the icon that looks like a server.

Then the transform data task is in the tasks tool box and looks like a cloud with an arrow. Select the oracle and sql connections and the select the transform data task.
0
 
JardITCommented:
There should be no need to write Active X script if the schemas are the same
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now