Devart SSIS Data Flow Components allow you to integrate database and cloud data via SQL Server Integration Services (SSIS).
Devart SSIS Data Flow Components provide easy to set up cost-effective data integration using SSIS ETL engine. They provide high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features.
Order Devart SSIS Data Flow Components for all 45 supported data sources in one Universal Bundle and get a fantastic discount! If you need SSIS Data Flow Components only for cloud applications, you may order SSIS Integration Cloud Bundle. For databases, there is SSIS Integration Database Bundle available.
For each of the supported data sources, Devart SSIS Data Flow Components include:
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.
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.
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.
