Released: Aug 15, 2023

V2.1.411 での更新項目

機能

• Quickly build SSIS-based integration solutions for Microsoft SQL Server.
• Automate SQL Server integration via SSIS Data Flow tasks.
• Import and export CSV files to SQL Server.
• Synchronize SQL Server with SQL Server or other data sources.
• SQL Server-specific Connection Features:
  • Support for secure SSL connections,
  • Connect via proxy, to set protocol version.
• Devart SQL Server Source Editor Component
  • Displays all the connection tables and their columns and allows you to quickly build a query to SQL Server 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 SQL Server 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 SQL Server Destination uses SQL Server-specific optimizations to speed up loading data to SQL Servers.