Using Data Transformation Services, part 3: Using the DTS Designer Objects (continued) - Creating the package: opening the editor
(Page 2 of 9 )
Expand the SQL 2000 Server node, right click on Data Transformation Services, and click New Package to open the DTS Designer as shown. DTS related menu as well as file operation menu items are available. Also available are the two collections: connections and tasks. Each item in the collection is identifiable by placing the mouse on the icon. The Package, Connection, Task, and Workflow menu items, when clicked, reveal the choices available by dropdown boxes as shown in the next couple of pictures. For details refer to the previous tutorial. Create a package called FileCreated.
Creating an SQL Server connection We will start with the SQL 2000 Server. Click on the Microsoft OLEDB Provider of SQL Server in the dropdown menu after clicking on the Connection menu item, or drag and drop the item from the connection collection on the left-hand side onto the design pane. This opens up the Connection properties window as shown. Since we have chosen to work with the Northwind example database, we set the database to Northwind. 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 Destination text file connection >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
