Version 20.1.0.1562 - June 5, 2020

This release comes with the following updates and enhancements:

  • New: We have introduced support for Marketing EmailMarketing Email Statistics in HubSpot Source & Destination components. 
  • New: We added a 'since' filter parameter in HubSpot Source component when retrieving recent modified companies.
  • New: HubSpot OAuth scope and optional scope are now configurable in HubSpot Token Generator.
  • New: HubSpot Connection Manager now supports working with a token file saved in Azure Blob Storage by specifying an Azure SAS url as the token file path.
  • Enhancement: We have switched to use token files instead of relying on Windows registry to store and manage authentication tokens for better security and easier deployment.
  • Enhancement: HubSpot 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: HubSpot Source component may fail with FormatException or DoesNotFitBufferException when executed in optimized mode and not all outputs were attached.
  • Fixed: You may find error "The PrimeOutput method returned success, but did not report an end of the rowset" in SSIS Execution Results when the HubSpot primary output is not attached.

Version 7.1 - November 29, 2019

This release comes with the following updates and enhancements:

  • New: HubSpot Source component now supports retrieving property history when working with Contact, Company and Deal objects.
  • New: We added support for working with Product and Line Item in HubSpot Source and Destination components. 
  • New: We added support for reading form submission when reading contacts in a list in HubSpot Source component.
  • New: We added support for using My Own App in HubSpot Connection Manager.
  • New: We added "sales-email-read" scope as an optional scope in the HubSpot OAuth authentication workflow. Due to recent HubSpot API changes, connections created without the "sales-email-read" scope will be restricted to read Email Engagement data, it is highly recommended to re-authorize with the new scope to get new tokens in HubSpot Connection Manager.
  • Update: We now use token files to save HubSpot tokens. 

Version 7.0 - October 3, 2019

This release comes with the following updates and enhancements:

  • New: We added support for working with Ticket in HubSpot Source and Destination components.
  • New: We added support for working with CRM Association in HubSpot Source and Destination components.
  • New: HubSpot Source component now supports retrieving deal associations when reading deals.
  • New: We added a 'since' filter parameter in HubSpot Source component when retrieving recent created/modified deals, which can be used to only return deals created/modified after the specified timestamp.
  • New: Creating deals in HubSpot Destination component now supports creating deal associations.
  • New: HubSpot Destination component now supports updating contacts with a batch size
  • New: We added associations.contentIds, associations.quoteIds, associations.ticketIds fields to Engagement object in HubSpot Source/Destination component.
  • Enhancement: We added the ability to quickly toggle numeric fields to different types in HubSpot Source component.
  • Enhancement: We improved the performance for mapping\unmapping columns in HubSpot 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: We improved Azure SSIS-IR licensing to avoid unexpected unsuccessful activations upon restart.
  • Fixed: HubSpot Destination component may fail to create contacts when incoming email value is null.

Version 6.0 - February 21, 2019

This release comes with the following updates and enhancements:

  • New: We have added support for SSIS 2019.
  • New: We have added support for reading Form Submissions.
  • Enhancement: Various UI enhancements and performance improvements.
  • Enhancement: The HubSpot Destination now supports returning the _HubSpotRecordId for Upsert actions with a Batch Size of 1.
  • Enhancement: We have added support for sending NULL values to HubSpot.
  • Enhancement: We have added the ability to quickly toggle Date and DateTime fields to DT_WSTR.
  • Fixed: The HubSpot source component may hang when reading recently created/modified contacts.
  • Deprecation: We removed support for SQL Server 2005.

Version 5.1 - August 17, 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 5.0 - April 26, 2018

This release comes with the following updates and enhancements:

  • New: We added support for reading Contact's form submission information in HubSpot Source component.
  • New: HubSpot Source component now outputs enumeration label values along with the internal values when reading from Deal, Company and Contact objects.
  • New: We added support of returning lastupdatetime when reading recent Campaigns in HubSpot Source component.
  • 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.
  • Enhancement: We added command line support for HubSpot Token Manager program.
  • 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).
  • Fixed: Parameterizing sinceDateTime in HubSpot Source component may not work properly.
  • Fixed: You may run into "Unrecognized Guid format" error when reading from Form object.
  • Fixed: You may get error "System.FormatException" when reading from EmailEvent in some unique situations.
  • Fixed: HubSpot Source component might crash if an invalid sinceDateTime is provided.

Version 4.2 - December 14, 2017

This release comes with the following updates and enhancements:

  • New: We added support for retrieving recently modified Engagement objects in HubSpot Source component.
  • Update: Update of licensing component to better support servers within a clustered environment to minimize potential false licensing errors.

Version 4.1 - October 6, 2017

This release comes with the following updates and enhancements:

  • New: We added support of reading recent Created contacts in HubSpot Source component.
  • New: We added a sinceDateTime filter parameter in HubSpot Source component, which can be used to retrieve contacts records relative to a given date when the Recently Created Only or Recently Modified Only option is enabled.
  • New: We added support for reading and writing Associated Deals.
  • 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 HubSpot are now made with the latest and greatest TLS protocol whenever possible.
  • Fixed: API Throtting Rate in HubSpot Connection Manager may not work properly for some particular timezones.
  • Fixed: "Auth In App" option in HubSpot Connection Manager does not include all scopes during the authorization.
  • Update: Some updates to the licensing component.

Version 4.0 - July 7, 2017

This release comes with the following updates and enhancements:

  • New: We added support for SQL Server 2017.
  • New: HubSpot connection manager now support listing existing tokens.
  • New: We added an expression button in HubSpot source components.
  • New: We added an expression button in HubSpot destination components.
  • Fixed: You may get error "Bad Request" when importing token in HubSpot Token Manager.
  • Enhancement: Improved high-DPI support.
  • Enhancement: Some minor GUI improvements.
  • Enhancement: We added command line support for License Manager program.
  • Update: We no longer deploy Newtonsoft.Json.dll assembly to Windows GAC.
  • Fixed: If you have an Ultimate trial license, it may still report as not licensed.

Version 3.0 - March 15, 2017

This release comes with the following updates and enhancements:

  • New: We added support for OAuth 2.0 authentication in the HubSpot connection manager.
  • New: We added a ProxyMode option to HubSpot connection manager, which now supports three types of proxy mode: No Proxy, Auto-detect and Manual. 
  • Update: We updated the service method to get metadata properties of Company, Contact and Deal as the old URLs are deprecated.
  • Update: We have an updated license agreement.
  • Fixed: We fixed the UI display issue under high DPI setting.
  • Fixed: You may get error "Could not determine JSON object type for type Microsoft.SqlServer.Dts.Pipeline.BlobColumn." when sending a DT_NTEXT type column to HubSpot destination component.

Version 2.0 - January 27, 2017

This release comes with the following updates and enhancements:

  • New: We added support for Engagement object in the HubSpot source component.
  • New: We added support for Engagement object in the HubSpot destination component.
  • New: We added options for receiving all records or recent created/modified records for Company and Deal objects in the HubSpot source component.
  • New: We added options for receiving all Contact records or recent Contacts in the HubSpot source component.
  • Update: HubSpot date type property now outputs in SSIS DT_DATE type.
  • Enhancement: Improved handling of retry on intermittent errors.
  • Enhancement: Updated the metadata for Campaign object.
  • Fixed: For some objects, the HubSpot destination component does not direct the defaut output rows.

Version 1.4 - October 24, 2016

This release comes with the following updates and enhancements:

  • Fixed: HubSpot components sends duplicate metadata calls when refreshing the components.
  • Fixed: HubSpot destination component might ignore the batch size setting when using "Upsert" action with Contact object.
  • Update: The license manager now supports co-termed subscription license.
  • Update: We have lowered the minimum requirement of SQL Server editions when using our software.

Version 1.3 - August 10, 2016

This release comes with the following updates and enhancements:

  • New: We added support for Campaign object in the HubSpot source component.
  • New: We added support for Email Campaign object in the HubSpot source component.
  • New: We added a new object called Contact Company Association in HubSpot destination component which can be used to associate/dissociate between contacts and companies.
  • New: We added a new filter parameter called listid in the HubSpot source component which can be used to read all Contact records in the specified list.
  • Fixed: HubSpot destination component might emit duplicate rows in its Default Output when using "Upsert" action with Contact object.
  • Update: We upgraded the JSON library (Newtonsoft.Json.dll) to the latest version (v9.0.1)

Version 1.2 - May 5, 2016

This release comes with the following updates and enhancements:

  • New: We added column/field filtering capabilities in HubSpot source component editor window.
  • 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.
  • Fixed: Incorrect data type for HubSpotRecordId column returned by the HubSpot destination component.

Version 1.1 - January 22, 2016

This release comes with the following updates and enhancements:

  • New: We have added support for SQL Server 2016.

Version 1.0 - September 15, 2015

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

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