New Versions of dotConnect ADO.NET Providers with Native SSIS Source and Destination Components!

September 5, 2013

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

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 components visually.

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.

Destination Components

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:

If you need another feature in our providers, visit our forum at UserVoice and vote for suggested features or suggest your own one.

If you wish to provide feedback on the new versions, you can do it in our forums or with contact form. There is also a feedback form in the support zone of every product. We are always glad to hear your comments and take into account your development needs.