OLEDB CONNECTION MANAGER

            OLEDB connection manager is required to access the data base object from the data base servers.

• Open the BIDS. Right click on the “Connection managers” and select “New OLEDB Connection”, find the below screen shot for reference.

• “Configure OLEDB Connection Manager” Window will open. Then click on the “New” button.

• “Connection Manager” window will open.

• Select the “provider” from the dropdown list. Give “Server name, Authentication and Data base”

• Press “Test Connection” to ensure that there are no connection errors. Press “OK”, then the “Connection Manager” window will disappear.
• Press “OK” button in the “Configure OLEDB Connection Manager” Window.

• “Configure OLEDB Connection Manager” Window will disappear.
• Connection manager creation is finished.

• If we need to modify the connection, right click on the connection (highlighted in the above screen shot) and select edit option.