OLEDB DESTINATION

            OLEDB destination is required to store the final result set into data base objects.

• From data flow items, drag and drop the “OLEDB Destination” into designer surface.

• Connect the source/transformation green arrow to the “OLEDB Destination”.

• For “OLEDB Destination” connection manager required to access the “data base objects”. So create a new connection manager (If connection manager not created).
• Right click on the “OLEDB Destination” and select “Edit” option. Then “OLEDB Destination Editor” window will open.

• Select the “OLEDB connection manager and Name of the table” from the drop down list.

• If target table is new table that we need to create, then click the "New" button. Find the highlighted part in the below screen shot for your reference.

• “Create table” window will open, with create table script. Modify the table name.

• Press “OK” button. Then “Create Table” window will get disappears.
• Table creation is finished.
• Click on the “Mappings” option in “OLEDB Destination Editor” window.

• Verify the mappings.

• Then press “OK” button. OLEDB Target mappings are finished, execute the package.