The package can be executed in any number of ways described in earlier tutorials. The easiest, while in editor is to click on Package, and then click Execute. This executes the package as shown here:
The DTS designer is mostly wizard driven and easy to work with. The querying of a text file in the DTS designer is not supported and hence an intermediate stage of porting the data to a table was devised. Now being a table, the full force of SQL querying can be used. The result was achieved without writing a single line of code (except for the Select statement in the query). The result of the query was then used to populate the destination text file. Another possible approach would be to use the file system object, read the input file, filter the file and then populate the destination table.
| 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. |
