As of our v20.1.0.1561 release, Our Xero toolkit has been deprecated in favor of our SSIS Productivity Pack. Please read details below.

Version 20.1.0 - June 5, 2020

This release comes with the following updates and enhancements:

  • Deprecation: Our Xero toolkit has been deprecated in favor of our SSIS Productivity Pack, which offers a much more sophisticated infrastructure to handle complex integration scenarios. You may continue to use the toolkit as long as you can live with the existing capabilities, however this version will be our last release of the Xero integration toolkit on its own, there will be no further enhancements or bug fixes offered going forward. SSIS Productivity Pack offers a collection of over 250 components which can significantly boost your SSIS ETL development productivity with Xero API support included through our REST component framework (including REST connection manager, REST source component, and REST destination component). Our API support in Productivity Pack comes with much greater flexibility. We highly recommend you upgrade before the toolkit stops working due to changes and evolvements of the API from the vendor side.

    Before finalizing the upgrade, we strongly recommend you complete the migration of your SSIS packages by downloading our SSIS Productivity Pack from its download page. Unfortunately, we don't have a tool that can convert the package automatically due to vast metadata differences between the two different products.

  • New: We added OAuth 2 support in Xero Connection Manager.
  • Enhancement: Xero 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.
  • 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: 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: You may get "Object reference not set to an instance of an object" error in Xero Destination component when Error Handling set to "Redirect rows to error output".
  • Fixed: You may not get proper Secondary Default Output rows and Secondary Error Output rows from Xero Destination component.

Version 4.1 - October 3, 2019

This release comes with the following updates and enhancements:

  • New: We added support of Allocation action for Credit Notes object in Xero Destination component.
  • 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.

Version 4.0 - February 21, 2019

This release comes with the following updates and enhancements:

  • New: We have added support for SSIS 2019.
  • Enhancement: Various UI enhancements and performance improvements.
  • Deprecation: We removed support for SQL Server 2005.

Version 3.1 - August 16, 2018

This release comes with the following updates and enhancements:

  • 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.

Version 3.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).

Version 2.2 - December 14, 2017

This release comes with the following updates and enhancements:

  • New: We added support of working with Attachment, InvoiceReminder and LinkedTransaction objects.
  • New: We added column/field filtering capabilities in Xero Source component editor window.
  • Fixed: Error handling in Xero Destination component may work improperly when 404 Not Found error occurs.
  • Update: Update of licensing component to better support servers within a clustered environment to minimize potential false licensing errors.

Version 2.1 - October 6, 2017

This release comes with the following updates and enhancements:

  • 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 Xero are now made with the latest and greatest TLS protocol whenever possible.
  • Update: There is an update 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 Xero source component.
  • New: We added an expression button in Xero destination component.
  • Enhancement: Improved high-DPI support.
  • Enhancement: Some minor GUI improvements.
  • Enhancement: We added command line support for License Manager program.
  • Fixed: The Xero Source component might crash when unselecting all columns in secondary output.

Version 1.1 - August 10, 2016

This release comes with the following updates and enhancements:

  • New: We added support of working with <Tracking Category> elements in child objects.
  • Enhancement: Updated metadata.
  • Update: We upgraded the JSON library (Newtonsoft.Json.dll) to the latest version (v9.0.1)

Version 1.0 - May 5, 2016

This is our first public release of SSIS Integration Toolkit for Xero software.

  • Three main components
    • Xero Connection Manager
    • Xero Source Component
    • Xero Destination Component
  • Support for SSIS 2016, 2014, 2012, 2008R2, 2008, or 2005
  • Support for the following four actions in Xero Destination Component
    • Create
    • Update
    • Delete