Creating a New Connection Manager
Once Task Factory is installed, you have access to new Connection Managers. Add a new Connection Manager by completing the following process:
Note: Once you've selected a new Connection Manager you are presented with the manager's options.
1. Open SQL Server Data Tools or BIDS. Select Project > New Connection Manager to open the Add SSIS Connection Manager window.
Note: The Add SSIS Connection Manager window opens with all available connection managers. A description of Connection manager for Task Factory denotes the Task Factory connection managers.
2. Select the desired Connection Manager, and then select Add to configure that Connection Manager.
Connection Managers in Task Factory
The following is a list of Connection Managers available in Task Factory: