SSIS Data Flow components

What is SSIS Data Flow components?

SSIS data flow components

Devart SSIS Data Flow Components enable you to integrate database and cloud data through SQL Server Integration Services (SSIS).

Devart's SSIS data flow components provide easy configuration of cost-effective data integration using the SSIS ETL engine. They provide high-performance data loading, convenient component editors, SQL support for data sources in the cloud, and many data source-specific features.

What you can do with Devart SSIS data flow components

• Export data from multiple sources to different file formats
• Import XML, CSV, and other files into cloud applications and databases
• Sync applications and cloud databases
• Migrate from one cloud application to another
• Replicate data from multiple cloud applications to relational databases
• Load data between multiple cloud and relational data sources
• Integrate multiple data sources via SSIS
• Migrate from one database to another

Components included

For each of the supported data sources, The Devart SSIS Data Flow Components includes:

Data flow source component

Devart SSIS Source components come with a convenient, easy-to-use 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 for databases and cloud sources.

Data flow target component

Devart SSIS target components enable fast data loading and data source-specific optimizations. They provide advanced error processing per line and allow you to return generated IDs (primary key values) to records that have been successfully inserted.

Data flow search component

Devart SSIS search components provide high-performance search transformation with advanced caching. To reduce the number of round trips to the server, they use SELECT statements that check multiple rows at the same time and cache the returned data to avoid querying the same rows again.

System requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD / SSD: 50 GB of free space on the main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768