OLE DB Source :
By using OLE DB Connection Manager, This Source extracts data from database.
Configuring OLE DB Source:
Steps to Configure OLE DB Source are following:
lDrag and Drop “Data Flow Task” from SSIS Toolbox in Control flow tab and double clicked on it.
lOnce Clicked on data flow task, Drag and drop OLE DB Source from Other Sources in Data Flow Tab.
lDouble click on this source ,OLE DB Source Editor window will open then Click on New Button to configure OLE DB connection manager.
lOnce Clicked on New Button, OLE DB connection manager window will open.
lOnce You clicked on New Button.You can select Server Name and Database Name to create connection and click on Test Connection Button to check weather connection is created successfully or not and then click on “Ok” button.
lOnce you clicked on “Ok” , below window will be appeared as then click on “ok ” button and select data access mode property
Data Access mode has two property:
I. Table or view : This property is used to select Tables or views which exists in a excel file.
II. Table name or View name variable: In this property,you need to provide the variable name for Table or Views .
III. SQL Command : In this Property, You can write SQL query to fetch the records from particular database.
IV. SQL Command from variable: In this property, you need to provide the variable for SQL Command.
lSelect Table or write Sql Command Text.
lClick on column button to check connectivity of columns.
lYou can view the data by clicking on “Preview Button”.
lNow you can click on “Ok ” button to complete configuration of OLE DB source.
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.