Using Data Transformation Services, part 6: Intro to Text Transfer with Filtering - Creating the package
(Page 2 of 5 )
Opening the Editor
Expand the SQL 2000 Server node and right click on Data Transformation Services and click New Package to open the DTS Designer (please see the previous tutorials for this step). DTS related menu as well as file operation menu items are available. Also available are the two collections, connections and tasks. Create a package called TextDTS.
Create a source file connection Select a Text File Source connection from the collection of connections (also review previous tutorials on this topic) and drop it on the DTS Designer's design pane. This brings up the dialogue for configuring the text file connections as shown in the next picture. Locate the input file on the hard drive by using the Browse... button as shown. This completes the source connection.
Creating an SQL Server connection We will first start with the SQL 2000 Server. Click on the Microsoft OLEDB Provider of SQL Server in the dropdown after clicking on the Connection menu item, or drag and drop the item from the connection collection in the left-hand side on to the design pane. This opens up the Connection properties window as shown. Since we have chosen to work with TestWiz database (any database can be used), we set the database to TestWiz. It is assumed that the SQL Server is local and Windows Authentication is going to be used. This adds the SQL Server Connection. If needed, a text annotation can be added and placed in close proximity to the object. The text annotation can be accessed from the menu. The font properties of any added text are configurable.
Next: Creating a Transform Data Task and a Destination Text File Connection >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
