Premium ADO.NET Components

via SSIS Productivity Pack

Integrate and migrate data to and from Premium ADO.NET with any other application or data source including Microsoft Dynamics 365, HubSpot, Smartsheet, and Salesforce, to name just a few.

  Download   Purchase

kingswaysoft data integration made easy

What other applications can you sync with Premium ADO.NET?
Click here for more solutions.


Premium ADO.NET

The Premium ADO.NET Source and Destination components offer expanded functionality to the out-of-box SSIS ADO.NET components, offering much greater performance, flexibility and ease of use with advanced datatype detection.

These components allows developers to not only retrieve and insert data into a database, but also allows them to use Update, Delete and even Upsert actions.

With the advanced options and functionality, our Premium ADO.NET components become a developer's go-to solution when reading or writing to virtually any database.


Supported Data Providers

The Premium ADO.NET Components support a wide range of data providers, including:

  • ODP.Net Managed
  • ODP.Net Unmanaged
  • ODBC Connections
  • OLE DB Connections

Retrieving data from a database using SSIS

  • Read from any database in SSIS easier with the Premium ADO.NET Source component which offers greater development flexibility and usability with superior performance.
  • Auto-generates select statement for retrieving data from the database source which can be further customized to perform powerful queries.
  • Developers can preview the results of their query prior to task execution.
  • Improved SSIS metadata handling means zero to minimum breaking changes to the downstream pipeline components when the source query is changed.

Premium ADO.NET SSIS Source Component

Premium ADO.NET SSIS Destination Component

Writing data to a database using SSIS

  • Use Create, Update, Delete, Upsert, Full Sync or Custom Command to write data to any database using SSIS.
  • Upsert data to your destination within minutes, no coding or advanced transformations required.
  • Create new tables, options for duplicate handling, and support for in-place lookup to easily perform lookup with more advanced features and no additional component configuration.
  • Support for Bulk Insert, Update, & Upsert available for some databases.

Premium ADO.NET Component
is available in the
SSIS Productivity Pack

DownloadPurchaseHelp Manual

Premium ADO.NET: Data Integration Made Easy

Our solution is easy to use, offering code-less integration between the Premium ADO.NET components and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.

Our Premium ADO.NET component is available within the Premium Data Flow components of our SSIS Productivity Pack, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate Premium ADO.NET with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.

See our full product offerings for more information.

Other Premium Data Flow Components

Our Premium Data Flow components make it easy to integrate with different services within the ETL process. Each component available has been specifically developed to expand and enhance data migration and integration processes. In addition to Premium ADO.NET, the Premium Data Flow components include:

SSIS Premium Aggregate Connector
Premium Aggregate
SSIS Premium Conversion Connector
Premium Conversion
SSIS Premium Derived Column Connector
Premium Derived Column
SSIS Excel Connector
Premium Excel
SSIS Premium Lookup Connector
Premium Lookup
SSIS Premium OData Connector
Premium OData
SSIS Premium PDF Source Connector
Premium PDF Source
SSIS Premium Recordset Source Connector
Premium Recordset Source
SSIS Premium Service Lookup Connector
Premium Service Lookup
SSIS Premium Slowly Changing Dimension Connector
Premium Slowly Changing Dimension

Get In Touch

If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!

Contact Us