The OLE DB connector is an object that is used to export data to a database using OLE DB drivers.
After adding the connector to the ETL task workspace, set basic properties and export options. The connector input and output can be also edited, and error handling parameters can also be set.
The Export Options page enables the user to specify connection parameters for data export.
Enter data consumer connection string manually or in the special dialog box. To activate the dialog box, click the 
button.
In the Table combo-box select or enter name of the table to be used as a data consumer. If the table does not exist, it is created after executing ETL task.
Selecting the Clear Consumer Before Loading Data checkbox enables the user to delete all information from the consumer before data loading.
See also: