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 […]

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

SSIS PowerPack v2.9.7 released

New Features/Improvements NEW: All API Tasks – Allow POST with empty body without throwing – 411 Error length required NEW: Amazon Storage Connection Manager – Add support for Tls 1.2 NEW: Amazon Storage Task, Azure Blob Storage Task – During download action replace invalid characters in file name to underscore (e.g. replace colon ) NEW: Breaking Change – SSIS 2008 is […]

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

SSIS PowerPack v2.9.6 released

What’s New In this release we added UPSERT support for PostgreSql and Redshift via our Upsert Destination. You can now choose connection manager for these 2 extra data source types and get fast bulk Upsert. We also fixed few important bugs with salesforce destination. Version 2.9.7.10822 [Sep 03, 2019] New Features/Improvements NEW: All API Tasks – […]

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

ODBC PowerPack v1.1.4 Released

What’s New In this version we focused on many bug fixes. Among them most important bug was limitation of only 2000 characters for SQL Query using OPENQUERY statement. Now you can use up to 8000 characters for OPENQUERY and if that’s not enough use EXEC AT statement to send query to Data Gateway. We also […]

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

ODBC PowerPack v1.1.3 Released

What’s New In this release we focused on adding URL JOIN Features which may allow many multi steps scenarios in one query. Bing Ads, Amazon MWS, Google BigQuery, Amazon Athena all these supports Job style queries which needs 3 step process (Create job, keep checking status, once done read report data). We also improved compatibility […]

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

SSIS PowerPack v2.9.5 released (Maintenance Release)

What’s New In this release we focused on fixing some bugs with Dynamics CRM Source , Dynamics CRM Destination and Reporting Services Task. Version 2.9.6.10621 [Jun 24, 2019] New Features/Improvements NEW: Excel Source – Add option to read from any sheet by number rather than hard coded table name (e.g. $4$ , $5$ … ) Bug fixes […]

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

SSIS PowerPack v2.9.3 released (Maintenance Release)

What’s New In this release we focused on mainly providing important BUG fixes / features. For example in this release we added feature in HTTP Connection to support HMAC Signature Authentication.  HMAC Auth enables API support like Azure CosmosDB. We also worked on few bug fixes for Salesforce Source and Amazon Redshift Data Transfer Task. Full […]

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

SSIS PowerPack v2.9.2 released (Maintenance Release)

What’s New In this release we focused on mainly focused on fixing high priority bugs related to Upsert Destination. We also added High DPI Monitor Support with Auto Scale UI option (4K Resolution now supported) Full Notes: https://zappysys.com/onlinehelp/ssis-powerpack/scr/release-notes.htm Version 2.9.2.10321 [Mar 21, 2019] New Features/Improvements NEW: Excel Source – Add Option to read first sheet and […]