The OLEDB Bridge Component allows you, in conjunction with the associated ADO.Net driver, to access an OLEDB connection via ADO.Net. This is useful in allowing you to access the full breadth of SQL Server Integration Services components to avoid having to define and maintain multiple connection strings, and it also enables you to share transactions across ADO.Net and OLEDB.

To define an ADO.Net connection that maps to an OLEDB connection, you simply need to include an OLEDB Bridge Component at the start of your package. Then double-click to configure.



Then click the 'Create Bridge Connection' button to create a new ADO.Net connection, and select the provider as 'BlueSSIS OLEDB Bridge Data Provider'. Then simply select the same of the OLEDB connection (as defined in your package) that you wish to map to where prompted.