What You Can Do with Devart SSIS Data Flow Components
- Export data from various sources to different file formats
- Import XML, CSV, and other files to cloud applications and databases
- Synchronize cloud applications and databases
- Migrate from one cloud application to another
- Replicate data from various cloud applications to relational databases
- Load data between various cloud and relational data sources
- Integrate various data sources via SSIS
- Migrate from one database to another
Included Components
For each of the supported data sources, Devart SSIS Data Flow Components include:
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.