Version 20.1.0.1561 - June 5, 2020

This release comes with the following updates and enhancements:

  • New: We have introduced support for Change Data Capture in the QuickBooks source component.
  • New: We added Minor Version support when working with QuickBooks Online in QuickBooks Source/Destination component.
  • New: QuickBooks Source component now automatically populate the necessary QBXML query when child entity is enabled while working with QuickBooks Desktop.
  • New: We added API Throttling Rate support in QuickBooks Connection Manager.
  • Enhancement: Hardened security in terms of how connection information is saved for QuickBooks connection manager.
  • Enhancement: QuickBooks Destination component now supports working with duplicate column names from upstream components as long as the columns are coming from different sources.
  • Enhancement: We have made some minor improvements in our retry implementation on intermittent errors.
  • Enhancement: Improved UI performance with select/unselect all output columns in QuickBooks Source component.
  • Update: We have adopted a new versioning strategy in this release. From this point on, all future releases will be versioned as YY.ReleaseWave.ServiceReleaseNumber.BuildNumber, where YY is the year in two digits. This helps simplify our communications with partners and clients in terms of a particular toolkit installation's maintenance status among many other benefits. This is implemented across the board for all of our SSIS toolkits including SSIS Productivity Pack. All our current releases should have the same version number of v20.1.0 with a revision number between 1561 and 1565.
  • Update: We have introduced a new branding panel in our UI forms to distinguish our components from those out-of-box ones.
  • Update:  Hardened security in terms of how connection information is saved for QuickBooks connection manager.
  • Update: We have switched to use token files instead of relying on Windows registry for better security and easier deployment.
  • Update: We updated .NET framework requirement to v4.6.1 for SSIS 2012 and above.
  • Update: Our license manager program now requires .NET Framework 4.0 or above. 
  • Fixed: QuickBooks Source component didn't output Budget Details values correctly when working with QuickBooks Online Budget object.
  • Fixed: You might get "Invalid query" error at runtime when using SSIS variable in source query in QuickBooks Source component.
  • Fixed: You may run into KeynotFoundException error in QuickBooks Source component when executed in optimized mode and not all outputs were attached.
  • Fixed: QuickBooks Components created by version 2.0 or earlier may not work if upgraded to v4.1.

Version 5.2 - November 15, 2019

This release comes with the following updates and enhancements:

  • Enhancement: QuickBooks Source component now handles invalid emun values better when working with QuickBooks Desktop objects.
  • Fixed: Login to QuickBooks Online may fail in QuickBooks Connection Manager, the Sign In page may redirect back to itself after login.
  • Fixed: QuickBooks Connection Manager may report a "400 (Bad Request)" error after user has provided the consent of using the OAuth App when authenticating to QuickBooks Online.
  • Fixed: When working with QuickBooks Desktop, Delete/Void actions in QuickBooks Destination component may not work porperly if the upstream pipeline has more than one input column.

Version 5.1 - October 3, 2019

This release comes with the following updates and enhancements:

  • Enhancement: There are some updates to the License Manager program that provide better tracking of license installation and easier license management by our client services team.
  • Enhancement: Improved Azure SSIS-IR licensing to avoid unexpected unsuccessful activations upon restart.
  • Fixed:  You may get "Exception from HRESULT: 0x80040302" error in QuickBooks Source component when reading from Customer object and the Enum type field contains an invalid value while working with QuickBooks Desktop.

Version 5.0 - February 21, 2019

This release comes with the following updates and enhancements:

  • New: We have added support for SSIS 2019.
  • New: QuickBooks Connection Manager is now using OAuth 2 by default when connecting to QuickBooks Online.
  • Enhancement: We have added support for reading child objects over a QuickBooks Online Connection Manager and using a QBO query.
  • Enhancement: We have improved the quality of metadata for QuickBooks components using a QuickBooks Online Connection Manager.
  • Enhancement: Various UI enhancements and performance improvements.
  • Fixed: The QuickBooks Source component may not refresh correctly when the 'Refresh Component' button is clicked.
  • Fixed: The QuickBooks Destination component may fail to send child object data.
  • Deprecation: We removed support for SQL Server 2005.

Version 4.1 - August 26, 2018 

This release comes with the following updates and enhancements:

  • New: We added support for "Orphaned Children Error Output" output in the QuickBooks Destination component. This is a breaking change, as a prior version (v4.0 or earlier) would not be able to process an SSIS package that contains a QuickBooks Destination component with the "Orphaned Children Error Output" output enabled. 
  • Enhancement: We have updated the license manager program to now report details of distinct connections in use.
  • Fixed: Our software may report a connection metering related error during runtime for some specific system environments.
  • Fixed: QuickBooks Desktop Gateway program may crash after clicking the Start button when using v4.0.

Version 4.0 - April 26, 2018

This release comes with the following updates and enhancements:

  • New: We added support for Azure-SSIS Integration Runtime (IR) deployment and licensing.
  • New: Standard use licensing model, this limits the number of distinct connections to 8 per connection type within a 24 hour period at runtime.
  • Update: We have an updated version of License Agreement that covers the new Azure-SSIS IR licensing model along with many other revisions - the new agreement becomes effective as of today (April 26, 2018).
  • Enhancement: Updated metadata. 
  • Enhancement: We added command line support for QuickBooks Token Manager program.
  • Enhancement: We added command line support for QuickBooks Desktop Gateway program.
  • Fixed: You may run into error "Input string was not in a correct format" when working with a number type field in QuickBooks Destination component.
  • Fixed: You may get "Index out of range" error when Error Output is enabled in QuickBooks Destination component.

Version 3.1 - December 14, 2017

This release comes with the following updates and enhancements:

  • Fixed: QuickBooks Destination Components created by version 2.0 or earlier may not work if upgraded to v3.0 when the component works with child objects. This fix introduces a new SSIS metadata upgrade, in order to work with our v3.0 capabilities. This fix should be considered a breaking change, as any packages will be silently upgraded once opened with v3.1 (or above), and the package will not work with a prior version after the upgrade is completed. 
  • Fixed: QuickBooks Destination component might send incorrect JSON requests when working with QuickBooks Online instance when the batch size is 1.
  • Fixed: We have removed some redundant metadata for QuickBooks Online, you may want to click the “Refresh Component” button for each QuickBooks component to get the latest metadata.
  • Fixed: You may run into "Specified cast is not valid" error when writing the QuickBooks Online using the QuickBooks Destination component.
  • Fixed: QuickBooks Desktop Gateway did not properly support certificates.
  • Fixed: When working with QuickBooks Online instance, the QuickBooks Destination component always tries to retrieve the sync token even one may have already been specified.
  • Enhancement: Improved high-DPI support.
  • Update: Update of licensing component to better support servers within a clustered environment to minimize potential false licensing errors.

Version 3.0 - October 6, 2017

This release comes with the following updates and enhancements:

  • New: We added support for QuickBooks on-premise desktop.
  • New: We added a documentation generation button to all SSIS components that can be used to generate a Word document which describes the component's metadata including relevant mapping, and so on.
  • New: Connections to QuickBooks are now made with the latest and greatest TLS protocol whenever possible.
  • New: Source component supports output timezone conversion.
  • New: Destination component supports input timezone conversion.
  • Enhancement: Some performance tuning and refactoring.
  • Update: Some updates to the licensing component.

Version 2.0 - July 7, 2017

This release comes with the following updates and enhancements:

  • New: We added support for SQL Server 2017.
  • New: We added an expression button in QuickBooks source component.
  • New: We added an expression button in QuickBooks destination component.
  • Enhancement: Improved high-DPI support.
  • Enhancement: Some minor GUI improvements.
  • Enhancement: We added command line support for License Manager program. 
  • Update: We upgraded the JSON library (Newtonsoft.Json.dll) to a more recent version (v10.0.2)
  • Update: We no longer deploy Newtonsoft.Json.dll assembly to Windows GAC.

Version 1.1 - May 5, 2016

This release comes with the following updates and enhancements:

  • New: We added support of reading line attribute from QuickBooks.
  • New: We added support for a few more entities.
  • Enhancement: Updated support for the latest SQL Server 2016 release candidate builds.
  • Enhancement: Running the 32-bit installation package on a 64-bit operating system is now blocked, as doing so makes our connection manager unrecognizable in 64-bit runtime.
  • Enhancement: We removed the requirement of .NET Framework 3.5 SP1 for SSIS 2012 and later.

Version 1.0 - January 22, 2016

This is our first official release of SSIS Integration Toolkit for QuickBooks software.

  • Three main components and application
    • QuickBooks Connection Manager
    • QuickBooks Source Component
    • QuickBooks Destination Component
  • Support for SSIS 2016, 2014, 2012, 2008R2, 2008, or 2005
  • Support for the following four actions in QuickBooks destination component
    • Create
    • Update
    • Hard Delete
    • Soft Delete