Devart SSIS Data Flow Components for SQLite released
Released: Aug 15, 2023
Mises à jour de v2.1.411
Fonctionnalités
- Quickly build SSIS-based integration solutions for SQLite.
- Automate SQLite integration via SSIS Data Flow tasks.
- Import and export CSV files to SQLite.
- Synchronize SQLite with SQL Server or other data sources.
- SQLite-specific Connection Features:
- Support for secure SSL connections.
- Connect via proxy, to set protocol version.
- Devart SQLite Source Editor:
- Displays all the connection tables and their columns and allows you to quickly build a query to SQLite via drag-n-drop.
- Displays the list of available system and user variables of the package, allowing you to quickly add them to your select statements.
- Quickly preview data, returned by the source, and check whether you query returns what you need.
- Advanced Lookup Optimizations:
- Devart SQLite Lookup component uses select statements that check several rows at once, and caches the returned results to reduce the number of round-trips to the server.
- Database-specific Optimizations:
- Devart SQLite Destination uses SQLite-specific optimizations to speed up loading data to SQLite.