OLEDB SOURCE

• From Data flow sources items drag and drop the "OLEDB source" into designer surface shown below.

•  OLEDB source is required "Connection manager" to access the data base objects.
• Create new "OLEDB connection manager".
• Right click on “OLEDB Source” and select edit option then “OLEDB Source Editor” window will open.

• Specify the Connection manager , Data access made and Table name from drop down list in “OLEDB Source Editor” window, shown below.

• After that press “OK” Button. 

 

• OLEDB source mappings are finished.