How to create a connection to Northwind in DTS Designer (Enterprise Manager)

To create a connection to Northwind in DTS Designer

1. From the Connection toolbar, drag a Microsoft® OLE DB Provider for SQL Server connection onto the Data Transformation Services (DTS) Designer design sheet.
   
   
2. In the New Connection box, type Cn1.
   
   
3. In the Data source list, click Microsoft SQL OLE DB Provider for SQL Server.
   
   
4. In the Server list, click local.
   
   
5. Do one of the following:
   • Click Use Windows Authentication.

   -or-

   • Click Use SQL Server Authentication, and then enter a user name and password.
6. In the Database list, click Northwind.