Devart is glad to announce the release of the new versions of
dotConnect for Oracle, dotConnect
for MySQL, and dotConnect
for PostgreSQL - enhanced database connectivity solutions, built
over the ADO.NET architecture, that support Entity Framework and LinqConnect ORM
solutions. New versions of dotConnect data providers offer you native Source and
Destination components for DataFlows in SQL Server Integration Services projects.
Source components of our dotConnect data providers are data flow components that
query data from the corresponding database and make it available for other DataFlow
components. They provide powerful editor dialog boxes, allowing you to tweak the
These editors display an object tree with available tables to select data from and
SQL Server Integration Services (SSIS) system variables allowing you to quickly
use their names in the queries.
Devart Destination components use database-specific features to load data quickly,
thus providing significantly higher performance for data loading that the standard
ADO.NET Destination component. They also allow advanced per-row error processing.
Destination components can return a set of columns, containing error code, error
columns, and error description for the rows, that caused an error.
You can read more about SSIS Source and Destination components in our articles: