Using Data Transformation Services, part 6: Intro to Text Transfer with Filtering - Configuring the Transform Data Task
(Page 4 of 5 )
As described in the previous tutorials connect the SQL 2000 Server with the destination text file created in the previous step by a Transform data task as shown:
Place the cursor on the arrow (Transform Data Task arrow) and when it changes to arrows pointing North-South (or East-West) right click to show the drop down menu. Click on the properties item. The Transform Data Properties window opens up with the Table/View as default as shown. Now choose to use a SQL query. This query can be fashioned in the editor as described in the earlier tutorials. Now create a query as shown here by entering the text, or using the GUI support in the editor. This query selects the three columns only if the column value is 20.
Now the source for the transformation is the SQL Server connection and the destination is the TransText.txt file. Open the Transform Data Task window and rearrange the column mappings from table/column1 to TransText.txt file's column1 to the ones shown here. Here you can click on Parse query.. to test if it has the correct syntax, or Preview.. the data using View Data . This completes the design of the package. This can be saved using the Save button. It can be saved in the SQL Server, or repository (the Meta Data Services node) in SQL Server's Data Transformation node, or to a file on the desired location as a *.bas file. In the present tutorial it is saved as a TextDts package and also as TextDts.bas file.
Next: Verification Package Results >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
