ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

ODBC PowerPack 1.3.0 released

Version 1.3.0.10909 [Sep 16, 2020] This version brings brand new JDBC Bridge driver which can connect data using any JDBC Driver in  ODBC Apps (e.g. Excel). Many vendors dont provide ODBC Driver because its expensive and complex to build so they simply supply you Java based JDBC Driver, however these JDBC drivers work only with […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

SSIS PowerPack 3.1.4 released

New Features/Improvements NEW: Dynamics CRM Destination – Add Support for Multiple Threads for faster performance (Added EnableParallelThreads, MaxParallelThreads Properties) NEW: General – Add new functions LOWER, UPPER, FUN_UNIX_TIMESTAMP_TO_DATE (When input is Seconds format) and FUN_UNIX_TIMESTAMP_MS_TO_DATE (When input is Milliseconds format) NEW: General – Add product Update notification (Show release notes when new available) NEW: General – Enforce License manager […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

SSIS PowerPack 3.1.3 released

New Features/Improvements NEW: HTTP Connection Manager – Allow option to set DynamicToken request as Form-Data (Multi-Part) request NEW: HTTP Connection Manager – For Dynamic Token option when Auth Scheme contains space do not suffix another space (e.g. MyAuthScheme sess-id=) NEW: JSON Source – Allow to set Custom Filter for Column Less 2D Array with First Line as Column […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

SSIS PowerPack v3.1.2 released

New Features/Improvements NEW: Dynamics CRM Destination – Allow to update OwnerID field in older CRM version (i.e. lower than v9) NEW: Dynamics CRM Destination – Use mapped type field in Update / Upsert operation to set EntityReference fields (e.g. ownerid ) – Right now system picks first type from Allowed LinkedEntity list (see Advanced Custom Properties) NEW: General […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

ODBC PowerPack 1.2.0 released

New Features/Improvements NEW: All API Drivers – Add Custom Stored Procedure support (With Compiled Metadata support for faster performance) NEW: All API Drivers – Add support for count(*) NEW: All API Drivers – Add support for multi statements NEW: All API Drivers – Add Support for Placeholder functions in HTTP Dynamic Token Request (i.e . Headers/Body/URL) NEW: All API Drivers […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

SSIS PowerPack v3.1.1 released

New Features/Improvements NEW: Amazon Storage Task, Azure Storage Task, Secure FTP Storage Task, Advanced File System Task – Add option to get latest /oldest file path from specified folder or pattern search NEW: General – Add Placeholder Function FUN_TIMESTAMP_UNIX to return Unix Style Timestamp of current UTC DateTime (i.e. epoch) (Usage 1325394000 or 1587560359 for Current time) […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

SSIS PowerPack v3.0.2 released

New Features/Improvements NEW: General – Upgrade Core dlls to Framework 4.0 NEW: OAuth Connection Manager – Add Validation for Changing Refresh Token File so user doesnt save Token Backup file to RefreshToken File Path by mistake Bug fixes FIX: JSON / XML Source – When you enable Array Flattening Option – You may get error – Failed to […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

SSIS PowerPack v3.0.1 released

New Features/Improvements NEW: Amazon SQS Source – Add columns for SequenceNumber, MessageGroupId and MessageDeduplicationId NEW: Amazon SQS Source, Azure Queue Source – Add option MaxRetryOnNullMessage to retry for N times before stop reading from queue NEW: Dummy Data Source – Add Random GUID support for DT_GUID type NEW: General – Add option to Import / Export Columns Mapping Grid […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

SSIS PowerPack v3.0.0 Released (with SQL Server 2019 Support)

We are excited to add support for SQL Server 2019 in this version along with many other improvements. Version 3.0.0.11216 [Dec 20, 2019] New Features/Improvements NEW: Add Support for SSIS 2019 (SQL Server 2019) NEW: General – Indicate NULL cell in Preview Grid NEW: General – Show LONG TEXT in Preview Grid – Add right click option to […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

SSIS PowerPack v2.9.8 released

New Features/Improvements NEW: CSV File Destination, Export CSV Task, CSV Generator Transform – Give option to escape Quote character inside value as per RFC4180 NEW: Export JSON Task – Provide an option (DoNotOutputParentIfChildRowNotFound) to exclude empty array property (hide from output if no children found under array node) NEW: Export JSON Task – Provide an option (DoNotOutputParentIfNestedPropertiesNull) to […]