All of the tasks in the OLEDB connector require a connection to an OLEDB database, so you will need to create a connection with the type ‘OLEDB Database’. See Connection Manager for instructions on creating a new connection. You will see a screen like the one below, requesting your OLEDB details:
Enter your OLEDB details as described below, then click ‘Finish’ to create the connection.
Allows you to specify any additional parameters for the connection string.
Enter the ‘properties’ parameter of the OLEDB connection string.
Enter the ‘provider’ parameter of the OLEDB connection string.
Enter the ‘source’ parameter of the OLEDB connection string.
Back | Edit on Github