Using Data Transformation Services - Part 1 - Executing the package/step
(Page 5 of 5 )
The package created can be executed by right clicking the package icon in the DTS Editor and choosing ExecuteStep, by choosing to execute from the menu item Package -> Execute, or by choosing Local Packages-> Jan2005_1 package in the file list and right clicking it to choose Execute Package. After taking the later two of these actions, the following screen comes up, executing the package immediately and, when finished, the next screen shows up, informing that the package was successfully executed. Execute step does not show the process being executed; it shows only the successful outcome window:
Here are the pictures of the explorer view of XPHTEK/Test before and after copying the database:
Summary
In this tutorial on Data Transformation Services, two of the important tools of the SQL 2000 Server were discussed, the Import Export Wizard and the DTS Editor. A package creation using the Import Export wizard was described. Executing the package immediately initiates and completes the export process as well as creating a package for future reuse.
The concrete step-by-step process of copying a database from one SQL server to another SQL server edition using the DTS editor was also described. The tutorials to follow will discuss the DTS API, the slightly more involved data transfer from a non-Microsoft product to a non-SQL server based data source, and so forth. DTS is a very powerful tool that makes data transfer a less arcane, more productive process. The DTS designer is an extremely easy to use interface, but at times some of the information stored in the wizard's form disappears (replaced by defaults) after one execution step if not saved immediately. This may be just a local malady, but forewarned is forearmed.
| 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. |
/ 36 
