Copying a Table from Oracle 10G XE to SQL 2000 Server using DTS - Executing the Package
(Page 4 of 4 )
With this, the configuration of the task is completed. From the Package menu item the package can be executed by clicking on the drop-down menu item Execute. This brings up the Execute Package window, which shows the progress of the package execution as shown. When it is completed, the Package Execution Results window pops up as shown.
You may click on the OK button, and on the Done button on the above windows to close them. You may save the package for future use, or for reference on the server as shown. A name has to be given to the package.
This shows the Employees table created on the TestRun database on the local server.
The table properties can be accessed from the database's table node as shown.
This next picture shows the original table from Oracle 10G XE as well as the table copied to the SQL 2000 Server.
Some of the package properties can be edited by accessing the submenu item Disconnected Edit... from the drop-down from the main menu item Package.
Summary
SQL 2000 server's DTS program works without a hitch copying a table from Oracle 10G XE to SQL 2000 Server. The Oracle connection uses a default ODBC connection, whereas in SQL 2005 server, the Integration Services uses the Native Clients and OLE DB providers. Configuring a similar task in Visual Studio's IDE requires attention to a lot more details and is not as intuitive.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 7 
