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 .
ADO.NET Source: By using .Net Provider, This Source extracts data from database.
Configuring ADO.NET Source:
Step 1. Drag and Drop “Data Flow Task” from SSIS Toolbox in Control flow and double clicked on it.
Step 2. Once Clicked on data flow task, Drag drop ADO.NET Source from Other Sources in data flow tab.
Step 3. Double click on this source ,ADO.NET Source Editor will open.
Step 4. Click on New Button to create connection manager and select 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 database.
II. Sql Command : In this Property, You can write SQL query to fetch the records from particular database.
Select Table or write Sql Command Text.
Step 5. Click on column Button to check connectivity of columns and click on preview button to view the data.
Step 6. Once clicked on “Preview Button”, the below window will open.
Step 7. Now you can click on “Ok ” button to complete configuration of ADO.NET 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.