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.