How to create a second connection to the Northwind database using DTS Designer (Enterprise Manager)

How to create a second connection to the Northwind database using DTS Designer (Enterprise Manager)

To create a second connection to the Northwind database using DTS Designer

1. From the Connection toolbar, drag a second Microsoft® OLE DB Provider for SQL Server connection onto the Data Transformation Services (DTS) Designer design sheet.
   
   
2. In the New Connection box, type Cn2.
   
   
3. Complete the remaining property selections as you did for the first connection.