The package is saved which may be password protected and saved with a user supplied name, in this case Trnsfrm. In the previous tutorials executing a package has been discussed. It can be done in several ways. From the Package menu item in the DTS editor click on Execute. You should see the successful execution message. Now you should be able to open up the MS Access database and look for the table. Presto!, here it is in the next picture with the table opened in data View mode.
The DTS designer together with the built in transformations as well as the ActiveX scripting support makes the data transfer a piece of cake. Some simple scripts were shown but in real production scenarios the code may get more complicated. When choosing the "Create Table" in MS Access we used the defaults that made the table appear as shown above. We could have made all the changes to the column names, etc which we did not. This tutorial only scratched at the surface of this tool, and the reader is advised to look for other references as well as get a firm grip on VB script scripting, especially with regard to string manipulation.
| 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. |
