SSIS package is tool to extract data from various sources ,transform and load into destination. It means you need various sources to extract the data .
Excel Source :
By using Excel Connection manager, This Source extracts data from Excel Sheet.
Configuring Excel Source:
Steps to Configure Excel 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 drop Excel Source from Other Sources.
lDouble click on this source ,Excel Source Editor will open.
lClick on New Button to create Excel connection manager.
lOnce Clicked on New Button, Excel connection manager window will open.You can browse Excel file by clicking on “Browse” button and Click on “Ok” button.
lSelect Data Access mode.
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 “Name of Excel sheet” to display the data for particular worksheet of Excel.
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 Excel 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.