Home arrow Oracle arrow Page 5 - Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005

Saving and executing the package - Oracle

Many enterprises need to move data from one kind of data source to another. This tutorial guides you through the steps necessary to move data from Oracle XE into a SQL 2005 Server database.

TABLE OF CONTENTS:
  1. Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005
  2. Call up the wizard
  3. The destination of the data
  4. The nature of the data transferred
  5. Saving and executing the package
  6. Wizard's Summary report
  7. Comparison of Department and Employees tables after importing
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 7
June 21, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

When you click on the OK button in the above screen, you will reach the stage where you may want to save the package for future use, execute the package immediately, or both save and execute the package. The last option is chosen in this case, according to the choices shown in the next screen. There are also two choices while saving: saving it to a file in the file system, or saving it in the MSDB folder in the Integrated Services server. MSDB is a sub-folder in the Stored Packages folder.

Protecting the package

When you click on the Next button you will be asked for the option you want to choose for protecting the package. There are several options including password and encryption. For the tutorial the Do not save sensitive data option was chosen.

When you click on the Next button in the above screen, your chosen features for saving before the final save action is shown. Like most of the other screens, you have a chance to back off at almost every step of the way. Here you may also make a choice of the authentication required for the package. The default, Windows authentication, is chosen here.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: