Devart released a first version of SSIS Components for PostgreSQL v1.0
It deliver performance-optimized SSIS Data Flow Source, Lookup, and Destination components for PostgreSQL.
Data Flow Source Component. Devart SSIS Source components come with convenient and user-friendly editor that visually displays the corresponding source objects and SSIS variables. It allows you to quickly configure your SELECT query that gets data. SQL SELECT statements are supported both for databases and cloud sources.
Data Flow Destination Component. Devart SSIS Destination components allow fast data loading and has data source specific optimizations. They offer advanced per-row error processing and allow returning generated IDs (primary key values) for records that were inserted successfully.
Data Flow Lookup Component. Devart SSIS Lookup components offer high-performance lookup transformation with advanced caching. To reduce the number of server round-trips, they use SELECT statements that check several rows at once, and cache the returned data to avoid querying the same rows again.