Using Data Transformation Services, part 6: Intro to Text Transfer with Filtering - Creating a Transform Data Task and a Destination Text File Connection
(Page 3 of 5 )
Create a Transform Data Task From the collection of connections and tasks, pick up a Transform data task and place it on the two connections, source connection first and destination connection [SQL Server], next. Now the designer pane should appear as shown here.
Now right click on the Transform Data Task and choose to look at the Properties from the pop-up menu. This brings up the Transform Data Task Properties window with multiple tabs for Source, Destination, Transform, etc. as shown here.
For the destination we will be populating a newly created table TestDts in the TestWiz database in the local SQL 2000 Server with the data from the source text file. We assume a simple column transfer, that is, column 1 in the text file goes over to column 1 in the table, and so on as shown. For more details please review the earlier tutorials in this subject.
Creating a Destination text file connection From the Connection menu item, select the Text File (Destination)... and drag it to the design pane of the editor. The editor's design pane now contains the SQL Server Connection as well as the TextFile (Destination) connection. Also create an empty text file TransText.txt located at a suitable location in the C: drive.
The connection properties for the TextFile (Destination..) is as shown in the next picture. Browse with the ellipsis button (...) to point to the TransText.txt created earlier. This becomes the destination for the results from the TestWiz database.
Next: Configuring the Transform Data Task >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
