How to create a connection (Enterprise Manager)

To create a connection in DTS Designer

1. On the Connection toolbar, drag the connection you want onto the Data Transformation Services (DTS) Designer design sheet.
   
   
2. Do one of the following:
   • Click New connection.
     
     
   • Click Existing connection, and then click an available connection from the list.
3. Complete the rest of the connection configuration information.

   The types of information will vary according to the particular data provider you choose.