SSIS package is tool to extract data from various sources ,transform and load into destination.
It means you need various destinations to load the data .
ADO.NET Destination: By using .Net Provider, This destination is used to load data into database.
Configuring ADO.NET Destination :
Steps to Configure ADO.NET Destination are following:
Drag and Drop “Data Flow Task” from SSIS Toolbox in Control flow and double clicked on it.
lOnce Clicked on data flow task, Drag drop OLE DB Source and ADO.NET Destination from SSIS toolbox.
lDouble click on this destination,ADO.NET Destination Editor will open.
lSelect Table or View property.
lClick on Mapping Button to check connectivity of Input columns and Output Columns.
lYou can view the data by clicking on “Preview Button”.
lNow you can click on “Ok ” button to complete configuration of ADO.NET destination.
lNow You can execute the package to load data into database.
lOpen Sql Server to preview the data which loaded by using ADO NET Destination.
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.