Steps to add Connection Managers

To add some connection managers to your package, follow these steps:

• Right-click in the Connection Managers area of your new package and select New OLE DB Connection.
• Note that the configuration dialog box will show the data connections that you created in Chapter 15; data connections are shared across Analysis Services and Integration Services projects. Click New to create a new data connection.
• In the Connection Manager dialog box, select the SQL Native Client provider.
• Select your test server and provide login information.
• Select the Chapter16 database.
• Click OK.
• In the Configure OLE DB Connection Manager dialog box, click OK.
• Right-click in the Connection Managers area of your new package and select New Flat File Connection.
• Enter DepartmentList as the Connection Manager Name.
• Enter C:\Departments.txt as the File Name.
• Check the Column Names in the First Data Row check box  

Shows the completed General page of the dialog box. 

                 

•  Click the Advanced icon to move to the Advanced page of the dialog box
• Click the New button.
• Change the Name of the new column to DepartmentName.
• Click OK.
• Right-click the DepartmentList Connection Manager and select Copy.
• Right-click in the Connection Managers area and select Paste.
• Click on the new DepartmentList 1 connection to select it.
• Use the Properties Window to change properties of the new connection. Change the Name property to DepartmentListBackup. Change the Connection String property to C:\DepartmentsBackup.txt.

Shows the SSIS package with the three Connection Managers defined.