Version 20.1.0.1561 - June 9, 2020

With this release, we have added support for 20 new services (APIs), 69 components among a total of over 500 new features, updates and enhancements. Here are the following updates and enhancements:

  • New Components
    • Cloud Storage
      • Azure Files Connection Manager
      • Azure Files Source
      • Azure Files Destination
    • Timing & Automation
      • Azure Functions Connection Manager
      • Azure Functions Source
      • Azure Functions Destination
      • Azure Functions Task
      • SSH Task
    • Message Queue
      • Premium Message Queue Task
    • Conversion
      • Composition
      • Decomposition
    • Premium Data Flow
      • Premium Aggregate
    • Premium Task
      • Premium Expression Task
      • Premium File Properties Task
    • Encryption & Compression
      • Premium Hash
    • Premium File Pack
      • WebDAV Connection Manager
      • WebDAV Source
      • WebDAV Destination
  • New services in REST
    • Acumatica
    • Azure Application Insights
    • Azure Tables
    • BaseCamp
    • BigCommerce
    • eBay
    • ElasticSearch
    • EventBrite
    • Facebook Messenger
    • FreshBooks
    • Insightly
    • Magento
    • LinkedIn Business
    • Sage Business Cloud
    • Teamwork
    • Twitter Business
    • Xero
  • [General] New: We added support for working with a token file stored in Azure Blob Storage by specifying an Azure SAS URL as the token file path for any Connection Manager that supports token file.
  • [General] Enhancement: All the Transformation components and Destination components in SSIS Productivity Pack now support working with duplicate column names from upstream components as long as the columns are coming from different sources.
  • [General] Enhancement: We have made some minor improvements in our retry implementation on intermittent errors.
  • [General] Update: We have updated our software signing by using a new certificate vendor, which might trigger a SmartScreen alert within the first couple of months from the release date. Rest assured we have done our best to make sure that your downloads from our website are trustworthy.
  • [General] Update: We have adopted a new versioning strategy in this release. Going forward, 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. All our current releases should have the same version number of v20.1.0 with a revision number between 1561 and 1601.
  • [General] Update: We have introduced a new branding panel in our UI forms to distinguish our components from those out-of-box ones.
  • [General] Update: We updated .NET framework requirement to v4.6.1 for SSIS 2012 and above.
  • [General] Update: Our license manager program now requires .NET Framework 4.0 or above.
  • Premium Data Flow Components
    • Premium ADO.NET
      • New: Premium ADO.NET Source component now supports using SSIS variables as table names when Custom Command option is used.
      • New: Premium ADO.NET Destination component now supports returning additional output columns.
      • New: Premium ADO.NET Destination component now supports writing to MySQL tables in Batch Insert mode and Bulk Insert mode when using MySQL Data Provider.
      • New: We added a "Write Mode" option in Premium ADO.NET Destination component, available options include: Row by Row, Batch and Bulk.
      • Enhancement: Premium ADO.NET components now automatically detect the supported Transaction Isolation Level for the specified connection manager.
      • Update: We removed the "Use Bulk" option in Premium ADO.NET Destination component.
      • Fixed: Premium ADO.NET Source component may report an "Only MySqlParameter objects may be stored" error when clicking the Preview button with a MySQL Data Provider connection in the case that an SSIS variable is used in the command.
      • Fixed: You may get an error "The target table 'target' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause" when performing Bulk Update/Upsert/Delete/Full Sync actions against a SQL table which has triggers defined.
      • Fixed: You may run into an error "Cannot insert duplicate key in object '{TableName}'" when performing non-bulk Upsert action against a SQL client connection manager. 
      • Fixed: You may get a "CLI0129E  An attempt to allocate a handle failed because there are no more handles to allocate" error in Premium ADO.NET Destination after writing thousands of records to an IBM DB2 table.
      • Fixed: Premium ADO.NET Destination may not report the detailed error message on each failed record when performing non-bulk Insert action and the Error Handling is set to "Redirect rows to error output".
    • Premium Excel
      • New: Premium Excel Source/Destination components support working with worksheet index now.
      • New: We added an "Ignore Cast Exception" option in Premium Excel Source columns, which can be used to prevent the component from failing should an InvalidCastException occur.
      • Update: We removed the "Specify End Row" option from Premium Excel Destination component when write mode is set to "Write to specific rows"
      • Fixed: Premium Excel components may not detect the format and background colors properly when Column Name option is set to Start Row.
      • Fixed: You may run into a "System.ArgumentException: An item with the same key has already been added" error when running multiple Premium Excel Source components to read from the same file simultaneously.
    • Premium Derived Column
      • New: We added the following functions to Premium Derived Column component:
        • Char()
        • Try()
        • FormUrlEncodedToJson()
        • GzipCompress()
        • GzipDecompress()
        • DeflateCompress()
        • DeflateDecompress(), 
      • New: HtmlEncode() function now supports representing by entity name.
      • Fixed: Expression NULL(DT_NTEXT) had an output data type of DT_WSTR(255).
      • Fixed: SubString() function was using test value for validation in Premium Derived Column.
      • Fixed: WriteValueToVaraible() may not work properly when Premium Derived Column is used in a Foreach Loop container.
      • Fixed: You may get an "Unable cast to type 'System.IConvertible'" error in Premium Derived Column when casting bytes to a numeric data type.
    • Premium Slowly Changing Dimension
      • New: We added support for using GUID column as surrogate key in Premium Slowly Changing Dimension component.
      • Fixed: "Use Bulk" option was disabled when writing to Oracle ODP.NET Unmanaged connection in Premium Slowly Changing Dimension component.
    • Premium Conversion
      • New: We added an "Ignore Cast Exception" option in Premium Conversion columns, which can be used to prevent the component from failing should an InvalidCastException occur.
      • Fixed: The Premium Conversion component may still report a NullReferenceException when Error Handling is set to "Redirect rows to error output".
  • Cloud Storage
    • Amazon S3
      • New: We added support for Set ACL action in Amazon S3 Destination component.
      • New: We added a new "Ignore Certificate Errors" option in Amazon S3 Connection Manager, which can be used to ignore any SSL certificate errors.
      • Fixed: You may get 'System.OutOfMemoryException' error while uploading large files (>1GB) to Amazon S3 using multi-threaded file uploading.
    • Azure Blob Storage
      • New: Azure Blob Storage Destination component now reports HTTP error status code in the ErrorCode column in the Error Output with a prefix of "800000" such as "800000409" to represent a 409 error..
      • Enhancement: Azure Blob Storage Source component has some significant performance improvement when file_content and the x-ms prefixed columns are not selected.
      • Fixed: You may get 'System.OutOfMemoryException' error while uploading large files (>1GB) to Azure Blob Storage.
    • Box
      • New: We added a "Max Depth" option in Box Source component, which can be used to specify how many levels of folders to read when reading in the recursive mode.
      • New: We added an "API Throttle Rate" option in Box Connection Manager.
      • New: We added support of using My Own App in Box Connection Manager.
      • Update: 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. 
      • Fixed: You may run into 404 Not Found error when updating tags of a folder record in Box Destination component.
      • Fixed: Downloading a specific file from Box using Premium File Transfer Task may not work properly.
      • Fixed: You may get a NullReferenceException error when downloading Box files recursively in Premium File Transfer Task.
    • Dropbox
      • New:  We added support of using My Own App in Dropbox Connection Manager.
      • Fixed: You may get a "The process cannot access the file because it is being used by another process" error in Premium File Transfer Task when uploading files to Dropbox.
    • Google Cloud Storage
      • Fixed: Google Cloud Storage Destination component may validate for required "ObjectResource" field but the field is not available in the destination metadata.
      • Fixed: You may receive a 'System.OutOfMemoryException' error while uploading large files (>1GB) to Google Cloud Storage.
    • OneDrive
      • New: We added a "Tenant Id" property in OneDrive Token Generator, which can be used to authenticate towards a specific Azure tenant.
  • Google Services
    • [All] Update: 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. 
    • [All] Fix: You may find a warning message in SSIS Execution Result that the Google token is generated using the app provided by KingswaySoft when the Google token was actually generated using My Own App.
    • [All] Fixed: You may receive a "System.NullReferenceException: Object reference not set to an instance of an object." error in Google Connection Manager when testing connection using Service Account authentication mode, this only happens to some unique system situations.
    • Google Analytics
      • New: Google Analytics Source component now supports outputting sampling information (sampleSize and sampleSpace).
      • New: We added support of specifying custom metrics and custom dimensions in Google Analytics Source component.
      • Enhancement: Improved handling of user permission errors when authenticating using Service Account in Google Analytics Connection Manager.
      • Fixed: You may run into NULLReference exceptions when testing connection in Google Analytics Connection Manager with a service account while a proxy is in use.
    • Google Ads
      • New: We added support for discovering available CustomerIds for the authenticated user in Google Ads Connection Manager.
      • Enhancement: Improved UI performance with select/unselect all output columns in Google Ads Source component.
      • Fixed: Google Ads Source component may crash when selecting LANDING_PAGE_REPORT report type.
    • Google BigQuery
      • Enhancement: We improved the error handling when authentication failed in Google BigQuery Connection Manager.
      • Enhancement: Improved UI performance with select/unselect all output columns in Google BigQuery Source/Destination component.
      • Fixed: Google BigQuery Source/Destination may fail listing all the datasets in a project when the project contains has more than 50 datasets.
    • Google Sheets
      • Update: We removed "Specify End Row" option from Google Sheets Destination component.
      • Fixed: You may run into a "Cannot deserialize the current JSON object' error" in Google Sheets Source/Destination component when the specified worksheet contains a filter view.
      • Fixed: Google Sheets Source component may fail with the "Input string was not in a correct format" error when reading an empty cell while the output column is in a numeric data type.
      • Fixed: You may receive an error "System.ArgumentException: Value does not fall within the expected range" in Google Sheets Destination when the default output is attached.
      • Fixed: Google Sheets Destination component may not work properly with NULL value with those non-string type fields.
  • HTTP/Web Services
    • New: Added a new AWS Signature authentication mode in HTTP Connection Manager, which supports Amazon Signature Version 4 and Signature Version 2.
    • New: We added support of Kerboros authentication mode in HTTP Connection Manager.
    • New: We added JWT authentication mode support in HTTP Connection Manager.
    • New: HTTP Connection Manager now supports Custom Token authentication by making a web request to retrieve an authorization token using a CURL command from a file, then extract the token from the web service response.
    • New: JSON/XML Source component now supports using variable as the source.
    • New: We added a new "Key Value Pivot" Output Type in JSON/XML Extract/Source component, which can be used to work with key/value pairs values.
    • New: JSON/XML Source component now supports @[ResponseStatusCode] token for expression evaluation.
    • New: We added an "Allow Data Truncation" option in JSON/XML Source component.
    • New: We added support of sending JSON formatted token request in OAuth Token Generator when the Content-Type request header is set to "application/json".
    • Update: HTTP Connection Manager now uses certificate thumbprint to specify the SSL certificate instead of using the certificate subject.
    • Update: We have renamed Credential authentication mode in HTTP Connection Manager to "Credential (Basic, Digest, NTLM)".
    • Update: HTTPRequestURL default output column in JSON/XML Destination component now has a default length of 4000.
    • Update: RequestURL output column in JSON/XML Source component now has a default length of 4000.
    • Update: The maximum allowed Max Identical value in JSON/XML Source component is now set to 500.
    • Fixed: You may find an error "The PrimeOutput method returned success, but did not report an end of the rowset" in SSIS Execution Results when a child output is enabled but not attached in JSON/XML Source.
    • Fixed: JSON/XML Source component may fail on 403 HTTP status code even though 403 has not been specified as an error code in HTTP Connection Manager.
    • Fixed: You may run into "Irony.Interpreter.ScriptException" error in JSON/XML Source component when running multiple JSON/XML source components 
      in parallel and the same project parameter is used in each source component.
    • Fixed: You may get NULL value in _HttpRequestIndex column in the HTTP Request Output in JSON/XML Source component.
    • Fixed: JSON/XML Destination component may report duplicate column validation error on [ErrorCode] column when the input contains a column named "ErrorCode". 
    • Fixed: The default output of JSON/XML Destination component may lost all output columns after metadata changes from upstream components.
    • Fixed: In some specific situations, you may get a NullReferenceException in JSON Source component after processing hundreds of records if the component is used in a Foreach Loop Container.
    • Fixed: JSON/XML Source component may fail reading the local file if the file is encoded in UCS-2 LE BOM.
    • Fixed: Encoded value "%20" in URL may get sent as "+" when testing connection in HTTP Connection Manager.
    • Fixed: HTTP Requester component may report OutOfMemory error when downloading a large file into the output DT_IMAGE field.
  • Mail Components
    • New: We added a "Post Retrieve Action" option in Email Source component, which can be used to delete or mark received email as deleted on the email server.
    • New: Email Source component now supports outputting the FolderPath of the email record.
    • New: We added support of getting email by MessageId in Email Source component for IMAP/Exchange Web Service connections.
    • Enhancement: Significantly performance improvement when working with Exchange Web Services protocol in Email Source if the Attachment output is not attached.
    • Enhancement: Some UI drag & drop improvement in WYSIWYG designer in SMTP Task/Destination component.
    • Fixed: SMTP Task/Destination component may not work properly when an image src path uses SSIS variables in the HTML email body.
  • NoSQL Components
    • New: CosmosDB Source/Destination component now supports working with raw document text as a column.
    • Enhancement: CosmosDB Destination component now validates the node type of the root node in order to prevent the "Object serialized to Array. JObject instance expected" error when the root node is accidentally set to an array.
    • Update: Cassandra/MongoDB Connection Manager now uses certificate thumbprint to specify the SSL certificate instead of using the certificate subject.
    • Update: We have renamed "Convert ObjectId to String" option in MongoDB Source component to "Convert Mongo types to strings" to better support MongoDB datetime values when "Output as JSON" option is enabled. 
    • Fixed: CosmosDB Source component UI always sets the same variable for the Input Variable and Output Variable when working with Document Change Feeds.
    • Fixed: You may get error "There is no Database named 'xxx'." when running multiple CosmosDB Source components in parallel.
    • Fixed: MongDB Destination component may write input datetime values in local system timezone while the component Input Timezone has actually been set to UTC.
  • Premium File Pack
    • New: Send Files and Delete Files actions in Premium File Transfer Task component now support filtering when working with Local/SFTP/FTPS connection.
    • New: We added a "Use Legacy Group Exchange" option in SFTP Connection Manager, which can be used to specify whether to use legacy form of Diffie-Hellman group exchange.
    • New: We added support of using wildcard characters within SFTP and local files in Premium File System Source component.
    • New: Premium File System Source component now supports filter parameters.
    • Update: FTPS Connection Manager now uses certificate thumbprint to specify the SSL certificate instead of using the certificate subject.
    • Fixed: You may get a "The connection was closed by the server" error when downloading files from SFTP server in recursive mode.
    • Fixed: Premium File System Source component may report a System.InvalidCastException error when outputting a string value to a DT_NTEXT field.
  • REST
    • [All] New: You can now use SSIS variables in the Filter Parameters grid in REST Source component.
    • [All] New: We added support for outputting raw response bodies in REST Destination component.
    • [All] Enhancement: Improved OAuth Configuration & Sign-In UI for all any REST connections that use a token file.
    • [All] Fixed: You may find an error "The PrimeOutput method on "REST Source" returned success, but did not report an end of the rowset" in SSIS Execution Results when a child output is enabled but not attached in the REST Source component.
    • Act-On
      • Fixed: Sending null values to Act-On to overwrite existing values may not work properly when performing Update action in Act-On REST Destination component.
    • ADP
      • New: We added support for "Codelists - Emp. Profile and Ben. Grps" endpoint in ADP REST Source component.
      • Update: The maximum batch size in ADP REST Source component is set to 100.
    • Facebook Business
      • New: We updated the API support to version v6.0.
      • New: Facebook Business REST Source/Destination component now supports using App Access Token.
      • Enhancement: Updated metadata.
    • Jira
      • Fixed: You may run into a BadGateway error in Jira REST Connection Manager when clicking the Generate Token button and the server URL does not end with "/".
      • Fixed: Jira REST Source component may fail with "System.ArgumentNullException: Value cannot be null. Parameter name: value" error when reading from Boards object while working with a Jira on-premise environment.
    • MailChimp
      • Enhancement: Better MailChimp metadata detection for the array of objects.
      • Fixed: You may run into error "The resource submitted could not be validated" in MailChimp REST Destination component when sending an empty string to a raw field with a batch size greater than 1.
    • Microsoft Teams
      • Enhancement: Updated metadata for the Chat Message object.
      • Update: We have updated some Microsoft Teams preview objects to use the Microsoft Graph REST v1.0 API.
    • MYOB
      • Enhancement: Updated metadata to support the Multi-location feature in AccountRight.
      • Fixed: Sending null values to MYOB to overwrite existing values may not work properly with Update action in MYOB REST Destination component.
    • Salesforce Pardot
      • New: We now support working with Salesforce Pardot custom fields that have Record and Display Multiple Response option enabled.
      • Fixed: Salesforce Pardot REST components may fail with an "Invalid API key or user key" error after the package has been running for over 30 minutes .
      • Fixed: Pagination in Salesforce Pardot REST Source component may not work properly with Campaign, List and Email Click objects.
      • Fixed: Salesforce Pardot REST Destination component might ignore the batch size setting when using Batch action with Prospect object.
    • ServiceNow
      • New: ServiceNow REST Connection Manager now supports specifying the service Base URL.
      • Update: We removed Instance Type from ServiceNow REST Connection Manager.
    • Shopify
      • New: We added support for cursor-based pagination in Shopify REST Source component to support version 2019-07 of the API and above.
      • New: We added support of using My Own App in Shopify REST Connection Manager for the Public App (OAuth) authentication mode.
      • Enhancement: Updated metadata.
    • Smartsheet
      • New: We added support of working with Smartsheet Gov Account.
      • New: We added a new Sheet  object in Smartsheet Source/Destination component to work with existing sheets in a tabular format by discovering the metadata from the sheet.
      • New: We added a new Report object in Smartsheet Source component to read from existing reports in a tabular format by discovering the metadata from the report.
    • SurveyMonkey
      • New: SurveyMonkey REST Source component now supports outputting the survey response in a flatten format through the new "Get Survey Response Answers in Bulk" endpoint.
      • Fixed: SurveyMonkey Source component may not return any records in SSIS pipeline when reading Webhook object even there were records returned.
    • WordPress
      • New: We added support of working with WordPress.com hosting.
      • Fixed: WordPress REST Source component may crash when there is a problem with the connection.
      • Fixed: WordPress REST Destination component might ignore the batch size setting when working with WooCommerce objects.
    • Wunderlist
      • Deprecation: We have removed Wunderlist support.
    • Zendesk
      • New: We added support for Zendesk Help Center API.
      • New: We added Zendesk incremental export API support, which can be used to retrieve delta changes in Zendesk Support since a given datetime.
      • New: Zendesk REST Source component now supports retrieving Ticket Comments along with the associated Attachments when working with Tickets object.
      • New: Zendesk REST Source component now supports retrieving User Identities when working with Users object.
      • New: We added a sinceDateTime filter parameter to Ticket Audits object in Zendesk REST Source component, which can be used to retrieve ticket audits records relative to a given date.
      • Enhancement: Improved handling of retry on HTTP 429 errors.
  • Data Quality and Comparison
    • Fixed: Diff Detector/Duplicate Detector component may report duplicate column validation error on [ErrorCode] column when the input contains a column named "ErrorCode".
  • Data Warehousing
    • New: Snowflake Source/Destination component now outputs the Snowflake queryId in the error message.
    • Update: We removed the Region option from Snowflake Connection Manager, user needs to specify the full account name in the Account property. Existing Snowflake Connection Manager should upgrade smoothly.
  • Encryption and Compression Tasks
    • New: We added a "Compression Format" option in Compression Task component, which allows you to compress/decompress the file in Zip, Gzip and Deflate formats.
    • New: Compression Task now supports wildcard when performing Decompress Zip file action.
    • Fixed: PGP Task may work improperly when performing Decrypt action and the key ring contains multiple private keys.
  • Message Queue Components
    • New: We added a "Use MQCSP Authentication" option in IBM MQ Connection Manager. 
    • Update: AMQP/RabbitMQ Connection Manager now uses certificate thumbprint to specify the SSL certificate instead of using the certificate subject.
    • Fixed: RabbitMQ Destination component may not close the connection properly during runtime when it is executed through SQL Server agent job.
  • Template Merge Components
    • Enhancement: Some UI drag drop improvement in WYSIWYG designer in HTML Merge component.
    • Fixed: HTML Merge component may work improperly when an image src path uses SSIS variables in.
    • Fixed: HTML Merge component may report duplicate column validation error on [ErrorCode] column when the input contains a column named "ErrorCode".
    • Fixed:HTML Merge component may work improperly when the input column or variable value contains HTML.
  • EDI Source Component
    • New: We added Error Handling support in EDI Source component to report Segment/Loop parsing errors.
    • Fixed: EDI Source component may output null values in the _ParentKeyFiled column when the parent output is not attached.
    • Fixed: You may receive a "System.NullReferenceException: Object reference not set to an instance of an object." error in EDI Source when working with some specific EDI files with "Flatten Loop Segments" option enabled.
    • Fixed: Importing an EDI file with repeated segments at the root level in EDI Source component may fail with a "There are multiple column nodes with the Data Name of 'xxx' underneath of the 'Root' output node" error.

Version 10.0 - October 3, 2019

This release comes with the following updates and enhancements:

  • New Components
    • Big Data
      • Hadoop Connection Manager
      • HDFS Source
      • HDFS Destination
      • Premium Data File Source
      • Premium Data File Destination
    • Cloud Storage
      • Azure Data Lake Storage Connection Manager
      • Azure Data Lake Storage Source
      • Azure Data Lake Storage Destination 
    • Data Warehousing
      • Snowflake Connection Manager
      • Snowflake Source
      • Snowflake Destination
    • Message Queue
      • AMQP Connection Manager
      • AMQP Source
      • AMQP Destination
    • Miscellaneous Components
      • Value Mapping
    • NoSQL Components
      • CosmosDB Connection Manager
      • CosmosDB Source
      • CosmosDB Destination
    • Premium Data Flow Components
      • Premium Conversion 
  • New Services in REST
    • Asana
    • Facebook Business
    • Infusionsoft
    • Microsoft Teams
    • MYOB
    • Twillio
    • Yammer
    • Zuora
  • [All] 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.
  • [All] Enhancement: Improved Azure SSIS-IR licensing to avoid unexpected unsuccessful activations upon restart.
  • NoSQL Components
    • DynamoDB
      • Fixed: Amazon DynamoDB Source component may output empty JSON arrays values "[,,]" when reading from DynamoDB list type attribute and the list is a collection of maps.
      • Fixed: Amazon DynamoDB Destination component may not report error properly when performing Upsert/Delete action with a batch size greater than 1.
      • Fixed: Amazon DynamoDB Destination component did not report error when Error Handling set to "Fail on error".
    • MongoDB 
      • New: We added Null Mode support in MongoDB Destination component, which can be used to specify how to handle NULL values.
      • Fixed: You may get "Index was outside the bounds of the array" error in MongoDB Destination component when writing to MongoDB _id field.
  • Cloud Storage
    • Box
      • Fixed: Box Connection Manager may crash when clicking on "Add User ID (In App)" button and the selected location had no existing tokens.
    • Amazon S3 
      • New: We added support for multi-threaded file upload in Amazon S3 Connection Manager.
      • Fixed: You may get "SignatureDoesNotMatch. The request signature we calculated does not match the signature you provided" error when deploying package with Amazon S3 components.
    • Azure Blob Storage
      • Fixed: Azure Blob Storage may fail with "System.DivideByZeroException: Attempted to divide by zero." error when performing Create action to Append Blob object with a chunk size of 0.
      • Fixed: You may run into "The MAC signature found in the HTTP request '' is not the same as any computed signature" error in Azure Blob Storage Destination component when performing Delete action.
    • Dropbox
      • Update: We removed Authorize In App option in Dropbox Connection Manager.
    • Google Cloud Storage 
      • Update: We added an option called "Upload Chunk Size" in Google Cloud Storage Connection Manager which helps the support of uploading large files.
      • Fixed: Google Cloud Storage Destination component may fail with "System.ArgumentException" error when writing to 'labels' field.
      • Fixed: Downloading Google Cloud Storage files using Premium File Transfer Task may not retain the original hierarchical structure.
    • OneDrive 
      • New: We added an "Impersonate As" option in OneDrive Connection Manager for OneDrive for Business connections, which can be used to access other user's OneDrive for Office global admins.
      • New: We added support of using My Own App in OneDrive Connection Manager.
      • Enhancement: The OneDrive connection manager starts to use the Azure AD app and the Graph API once authorized in the new version, and it will be using a token file going forward for better security and portability. Existing connection manager should still function by using registry-based token and old API service endpoints, we do however recommend moving to the new token file option.
      • Update: We have updated our OneDrive components to use Microsoft Graph API for both OneDrive Personal and OneDrive Business connections.
      • Update: We have updated our KingswaySoft OAuth app to Azure AD app.
      • Update: We now use token files to save OneDrive tokens. 
      • Fixed: You may get a validation error "Please select a file" in Premium Flat File/Premium Excel components when selecting an OneDrive SharedWithMe file.
  • Message Queue
    • IBM MQ
      • Fixed: You may get NULLReference exception when testing connection in IBM MQ Connection Manager if the authorized user doesn't have a password.
    • Azure Service Bus 
      • New: Azure Service Bus Source component now supports specifying a maximum number of messages to retrieve messages.
    • Amazon SQS 
      • New: We added support of Change Message Visibility action in Amazon SQS Destination component.
      • Fixed: Amazon SQS Source component may output expired ReceiptHandle value if the message was retrieved more than once.
      • Fixed: Extend Automatically option in Amazon SQS Source was not working properly.
      • Fixed: Amazon SQS Destination component may fail sending MessageDeduplicationId if the input column is non-string type when sending messages.
      • Fixed: Amazon SQS Destination component may send empty message body if the Body Column Type is set to Text when performing Send Message action.
  • Premium Data Flow Components
    • Premium Excel 
      • New: We added support for Excel 2019 in Premium Excel components.
      • New: Premium Excel Source/Destination component now supports working with hyperlinks.
      • New: We added formatting support in Premium Excel Destination component.
      • New: We added support of specifying sheet name in Premium Excel Destination component, the component will create the sheet if the specified sheet name not exist in the target file.
      • Fixed: Premium Excel Source component did not save the column data type changes when using "Start Row" for the column names.
    • Premium Slowly Changing Dimension 
      • New: Premium Slowly Changing Dimension component now supports writing to a Snowflake table directly through a Snowflake Connection Manager.
      • Fixed: Premium Slowly Changing Dimension component may report "System.ArgumentNullException: Value cannot be null. Parameter name: key" error if the component was executed from an SSIS Execute Package Task.
    • Premium Lookup
      • Fixed: You may run into error "NullReferenceException: Object reference not set to an instance of an object" when using fuzzy match with special match types in Premium Lookup component.
      • Fixed: You may get "Generic.KeyNotFoundException" error in Premium Lookup component when using fuzzy match with special match types and the Lookup table is empty.
    • Premium ADO.NET
      • New: We added Implicit Transaction Type support in Premium ADO.NET Source/Destination component.
      • New: Premium ADO.NET Destination component now supports using a permanent temporary table when performing Bulk Update/Upsert/Delete and Full Sync actions.
      • Enhancement: Significantly performance improvement with the writing actions in Premium ADO.NET Destination component in non-bulk mode.
      • Enhancement: Performance enhancement in Premium ADO.NET Destination component when no output attached while performing Bulk Update/Upsert/Delete and Full Sync actions.
      • Fixed: You may run into "[DB2/NT64] SQL0104N  An unexpected token "[" was found following "SELECT * FROM "." error in Premium ADO.NET components when loading DB2 metadata with DB2 OLEDB provider.
    • Premium Derived Column
      • New: We added the following functions in Premium Derived Column component: JoinStringArray(), EscapeUriDataString(),  UnescapeUriDataString(), FormContentUrlEncode(), FormContentUrlDecode(), Sleep().
      • New: We added format string support in string cast functions: DT_WSTR, DT_STR, DT_TEXT, DT_NTEXT.
      • New: (DT_BOOL) cast function now supports more string values (case insensitive): "y", "n", "yes", "no", "t", "f".
      • Enhancement: Better data length detection for functions with static results.
      • Fixed: Milliseconds works improperly in DateTime functions, you may get 0 for function DatePart( "ms", GETDATE() ).
      • Fixed: Casting DT_DBTIMESTAMPOFFSET data types in Premium Derived Column may fail with "Unable to cast object of type 'System.DateTimeOffset' to type 'System.IConvertible'" error for expressions like (DT_DBDATE)[DateTimeOffset].
  • REST
    • New: We added an Expand Fields feature in REST Source component, which can be used to select additional outputs or fields from the returned object from the server. 
    • New: We have updated the child outputs name in REST Source component to a name foramt of "{parent_output_name} -> {child_output_name}", so that the output names will be shown in a hierarchical tree structure in SSIS. This change should be considered as a breaking change, as a prior version (v9.0 or earlier) would not be able to open or process an SSIS package saved by the new version.
    • New: We have introduced a new token file format when using OAuth authentications in REST Connection Manager when working with Act-On, MailChimp, ServiceNow, Smartsheet, Square, Zendesk services. The new token file is json formatted and only has the sensitive information encrypted, a prior version (v9.0 or earlier) of Productivity Pack would not be able to open or process the new format token file.
    • New: Various UI enhancements.
    • ServiceNow
      • New: We added support for _attachment object in ServiceNow REST Source component by utilizing ServiceNow Attachment API.
      • New: ServiceNow REST Destination component now supports working with system fields by setting sysparm_suppress_auto_sys_field value accordingly.
      • Enhancement: We have improved the quality of metadata in ServiceNow REST components to support extend tables.
      • Enhancement: Better metadata detection to support Delete actions for ServiceNow objects in REST Destination component.
      • Fixed: You may find "[SSIS.Pipeline] Error: No object exists with the ID -1." error in SSIS Execution Results when executing a ServiceNow REST Source component.
    • Slack 
      • Fixed: You may get error "Unexpected character encountered while parsing value: [. Path 'definitions.objs_user_profile.properties.fields.type'" when getting Slack metadata in Slack REST component.
    • Zendesk
      • New: We added support of downloading attachment content when working with Attachment object in Zendesk REST Source component.
      • New: We added comment.uploads field to Ticket object when performing Update action in Zendesk REST Destination component, which can be used to attaching files to ticket.
      • New: Upload Attachment action in Zendesk REST Destination component now supports outputting _AttachmentToken in its default output.
    • Trello:
      • New:We added support of downloading attachment content when working with Attachment object in Trello REST Source component.
      • New: Reading from Action and Card objects in Trello REST Source component now supports pagination.
    • Square
      • Enhancement: Updated metadata.
      • Update: We have updated our KingswaySoft Square OAuth app to the latest API version. 
    • ADP
      • New: We added a Mask Data option in ADP REST Source component, which can be used to get unmasked sensitive data from ADP.
      • Fixed: ADP REST Source component may report NullReferenceException error when reading from workers with pagination.
  • HTTP/Web Services
    • New: We added Preview support in HTTP Requester Task and Web Service Task components.
    • New: HTTP Requester component now supports working with HTTP Multipart response.
    • New: We added a new option called ThrottlingRateUnit in HTTP Connection Manager.
    • New: We addes support of compressing the request body by specifying a Content-Encoding header in HTTP Connection Manager.
    • New: We have added the ability to remove the Accept-Encoding header from requests by adding Accept-Encoding as a default custom header in the HTTP Connection Manager
    • New: You can now use SSIS variables in the Input Parameters grid in Web Service Source component and Web Service Task.
    • New: Web Service Destination component now supports output response columns from the WSDL file.
    • New: We added a "Field Expansion Depth" option in Web Service components (Source, Destination and Task).
    • New: The HTTP connection manager now supports selecting a list of pre-defined HTTP headers. 
    • New: We have introduced a new token file format in HTTP Connection Manager when using OAuth authentications, the new token file is json formatted and only has the sensitive information encrypted. A prior version (v9.0 or earlier) of Productivity Pack would not be able to open or process the new format token file.
    • Enhancement: Better metadata detection when importing WSDL in Web Service components.
    • Update: We updated the default HTTP Method to POST in Web Service Task component.
    • Update: We removed Export Settings button in the OAuth Token Generator. Token file created in the new format will be used as the settings file as well. Settings file created in a prior version (v9.0 or earlier) of Productivity Pack continues to work when importing in the OAuth Token Generator.
    • Fixed: Web Service Source and Web Service Task components may not show any input parameters if the selected operation in the WSDL file has no input columns.
    • Fixed: You may get error "Unable to cast object of type 'System.Xml.XmlElement' to type 'System.Web.Services.Description.ServiceDescriptionFormatExtension'" in Web Service components when importing some specific WSDL files.
    • Fixed: Web Service Destination may output NULL ResponseBody value if RequestBody column is not enabled.
    • Fixed: HTTP Requester component may report error "Stream was not readable" when 'ResponseBodyError' column is enabled in Error Output and the corresponding error response has an empty body.
  • JSON & XML Processing
    • New: We introduced a new Document Designer in JSON/XML components, which supports more complex structure of the JSON/XML file. This change should be considered as a breaking change, as a prior version (v9.0 or earlier) would not be able to open or process an SSIS package saved by the new version.
    • New: We added format string support in JSON/XML Merge/Destination component.
    • New: We added encoding support in JSON Extract/Merge component.
    • Enhancement: Significantly performance improvement when working with large JSON/XML files in JSON/XML components.
    • Enhancement: Better memory usage when processing large JSON/XML files in JSON/XML components.
    • Update: JSON/XML Source/Extract component no longer output the raw _json and _xml fields, packages designed using these _json and _xml columns need to be updated to remove using them.
    • Fixed: You may get NULLReferenceException in XML Extract/Source component when the imported XML file has no schemaLocation defined.
  • Premium File Pack
    • SFTP 
      • New: Key authentication Method in SFTP Connection Manager now supports specifying password.
      • Fixed: You may run into "Channel closed" error when using Streamed Download to download files from SFTP server.
    • Premium Flat File 
      • New: We added decompress/compress the file support in Premium Flat File Source/Destination component.
      • New: We added format string support in Premium Flat File Destination component.
      • New: We added support of specifying Text Qualifier at the columns level in Premium Flat File Destination component, the default option is 'Auto'.
      • Enhancement: More efficient memory usage when working with large files whether on cloud or on premise.
      • Fixed: Premium Flat File Destination component may not respect the system locale setting when writing datetime values.
      • Fixed: Premium Flat File Source component may output 0 rows when Row Filter "Skip Last Rows" is used.
    • Premium File Transfer Task
      • Fixed: Premium File Transfer Task may report "The item already exists" error when performing Send Files action to a cloud storage service while the source file doesn't exist at the specified destination path.
  • Data Generation and Anonymization
    • New: We have added the following new spawn/anonymization types to the Data Spawner and Data Anonymizer components: Name Prefix, Name Suffix.
    • Fixed: Data Spawner/Anonymizer may generate duplicate Firstname and Lastname pairs when using Person entity with a seed.
    • Fixed: You may get random State value in Data Spawner/Anonymizer with a specific Country setting when the State column is part of an Address entity.
  • Data Quality and Comparison
    • Enhancement: Some code refactoring for better performance in Diff Detector component when the Business Key field uses exact First Name Match.
  • Google Services
    • New: We added Google Service Account authentication support in all Google Connection Managers and Google Token Manager.
    • New: We added support of specifying redirect_url when using "My Own" authentication type mode in all Google Connection Managers and Google Token Manager.
    • New: We added Authorize In Browser support in all Google Connection Managers and Google Token Manager.
    • Fixed: You may get "invalid request" error in Google components after the access token is expired.
    • Google Big Query
      • Fixed: Google BigQuery Destination component may fail inserting TableData if the input column value contains new line characters.
      • Fixed: Table drop-down list in Google BigQuery component may not list all tables if the specified dataset has more than 50 tables
  • Encryption and Compression Tasks
    • New: We added support for specifying Key Size when generation PGP key pairs in PGP Task.
    • Fixed: PGP Task may fail with "System.Exception: exception decrypting secret key" error when decrpting a file and the a key ring contains multiple private keys.

Version 9.0 - February 21, 2019

This release comes with the following updates and enhancements:

  • [All] New: We have added support for SQL Server 2019.
  • [All] Enhancement: Various UI enhancements and performance improvements.
  • [All] Deprecation: We removed support for SQL Server 2005.
  • Cloud Storage
    • New: We added the following new components:
      • Google Cloud Storage Connection Manager
      • Google Cloud Storage Source
      • Google Cloud Storage Destination
  • REST
    • New: We have added the following services to REST components:
      • ADP
      • PayPal
      • Salesforce Pardot
      • ServiceNow
      • Shopify
      • Smartsheet
      • Stripe
      • Trello
      • WordPress/WooCommerce
      • Wunderlist
    • New: You can now search for objects & endpoints in the REST source and destination components
    • Enhancement: We have added icons to help distinguish REST services when selecting a service from the REST Connection Manager editor, or select and Connection Manager from the REST Source or Destination component editors.
    • Enhancement: We have improved error messages during failed authentication in Jira REST components.
    • Enhancement: We have improved the quality of metadata in Zendesk REST components.
    • Enhancement: We have improved the quality of metadata in Freshdesk REST components.
  • HTTP, JSON, XML, Web Service
    • New: We have added the ability to define HTTP error codes and set them as retryable or not retryable in the HTTP Connection Manager.
    • New: We have added the ability to remove the Expect: 100-continue header from requests by manually specifying it in the HTTP connection manager
    • New: We added support for more HTTP related additional output columns in JSON and XML Destination components.
    • New: We added support for specifying static values underneath array nodes in JSON Merge and Destination components.
    • New: We have added a ‘Qualified Output Names’ checkbox to the JSON Extract, JSON Source, XML Extract, and XML Source components. This will make sure output names are unique when importing documents
    • New: JSON Extract and Source components now support importing JSON Schema documents.
    • New: We have added the ability to import YAML files into JSON Extract and Source Components
    • Enhancement: JSON and XML Extract components now pass through upstream columns to the root output.
    • Enhancement: We have made headers case insensitive when working with HTTP components (e.g. JSON Destination) and the ‘GetValueFromPreviousResponseHeaders’ function
    • Enhancement: We have improved the error message when errors occur during expression evaluation in JSON Source, JSON Extract, XML Source, and XML Extract components.
    • Enhancement: We have improved the ability to parse different types of WSDL files in Web Service Components.
    • Enhancement: Web Service Source components can now send valueless parameters.
    • Enhancement: The JSON Source, JSON Extract, XML Source, and XML Extract components now support more than 1 logical root output.
    • Fixed: The JSON Source, JSON Extract, XML Source, and XML Extract components may not have correctly generated outputs when importing settings.
    • Fixed: The JSON Source, JSON Extract, XML Source, and XML Extract components may have failed if executed in optimized mode and not all outputs were attached.
    • Fixed: The XML Extract component may have failed if input XML was NULL.
  • Premium ADO.NET
    • New: We added support for Transaction Isolation Level in the Premium ADO.NET Source and Destination components.
    • New: We added support for Pre and Post commands in Premium ADO.NET Destination component.
    • Enhancement: The Premium ADO.NET Destination component now maintains the scale of DateTime2 fields over a SQL client connection manager.
    • Deprecation: We have removed the Identity Insert option in the Premium ADO.NET Destination component because we now handle it internally as needed.
  • Data Spawner/Anonymizer
    • New: We have added the following new spawn/anonymization types to the Data Spawner and Data Anonymizer components:
      • Address Line 1
      • Address Line 2
      • Country (ISO Alpha 2)
      • Country (ISO Alpha 3)
      • Country (ISO Numeric)
      • Credit Card CVV
      • Credit Card Number
      • Credit Card Type
      • Email (Business)
      • Email (Personal)
      • Facebook URL
      • Gender
      • Identification Number
      • Regex
      • State/Province
      • State/Province Abbreviation
      • Static Value
      • Street Name
      • Twitter Url
      • Zip/Postal Code
    • New: We have added support for specifying a random seed at the column level for both the Data Spawner and Data Anonymizer components.
    • New: We have added the ability to generate connected data in the Data Spawner and Data Anonymizer components via Entities.
    • Enhancement: We have added expression support for anonymization type specific custom properties. (e.g. MinYear and MaxYear properties for the Date Time anonymization type).
    • Deprecation: We have removed the following spawn/anonymization types from the Data Spawner and Data Anonymizer components because they have been replaced with better ones:
      • CountryAbbreviated
      • Email
      • StreetAddress
      • UkCountry
      • UkPostalCode
      • UsState
      • UsStateAbbreviated
      • ZipCode
  • Premium Derived Column
    • New: We have added support for comments (both single and multi-line) in Premium Derived Column expressions.
    • Enhancement: We now maintain line breaks and whitespace in Premium Derived Column expressions.
    • Fixed: Your Premium Derived Column component may have failed if one of the expressions was using a string function that contained a NULL parameter.
  • Message Queue
    • New: We have added throttling to Rabbit MQ connection managers.
    • New: We have added SSL support to IBM MQ connection managers.
  • MongoDB
    • New: We have added the ability to control how to handle UUID fields by specifying the BinData subtype (3 or 4) in the MongoDB Connection Manager.
    • Fixed: Your MongoDB source component may have returned NULL for multi-level (dot-delimited) fields.
  • Premium File Pack
    • New: We have added the ability to preserve timestamps when sending files in the Premium File Transfer Task over supported Connection Managers.
    • New: We have added row filtering options in the Premium Flat File Source component.
  • SFTP/FTPS
    • New: We have added the ability to output the log in the SFTP Connection Manager.
    • New: We have added the ‘Transfer Type’ option in the FTPS Connection Manager.
    • New: We have added support for logging in the FTPS Connection Manager.
  • PGP
    • New: We have added the ability to rename files after being decrypted in PGP Tasks.

Version 8.1 - August 17, 2018

This release comes with the following updates and enhancements:

  • New: We added the following new components:
    • REST Components
      • REST Connection Manager
      • REST Source
      • REST Destination
    • Message Queue Components
      • Amazon SQS Connection Manager
      • Amazon SQS Source
      • Amazon SQS Destination
    • Google Services
      • Google Ads Connection Manager
  • New: We added the following services to REST components:
    • Act-On
    • Constant Contact
    • Freshdesk
    • Jira
    • MailChimp
    • Slack
    • Square
    • SugarCRM
    • SurveyMonkey
    • Zendesk
  • New: OAuth Token Generator now supports OAuth 1 authentication type.
  • New: We added a Lookup feature in Premium ADO.NET Destination component.
  • New: We added a new option called "Prevent Null Overwrite" in Premium ADO.NET Destination component, which can be used to ignore any fields that have a null value. By ignoring a field, the null value will not be sent to the target table.
  • New: We added MongoDB change streams support in MongoDB Source component.
  • New: We added 7 new functions to the Premium Derived Column component, which provide support computing HMAC.
  • New: HTTP Requester data flow component now supports getting custom response header values.
  • New: We added a new option called "Row Delimiter" in Premium Flat File Source/Destination components, which can be used to correctly parse files with rows.
  • New: Premium Excel Destination component now supports create the file/sheet at the specified location when the file/sheet does not exist.
  • New: We added support for "Orphaned Children Error Output" output in the JSON/XML Merge/Destination component. This is a breaking change, as a prior version (v7.1 or earlier) would not be able to process an SSIS package that contains a JSON/XML Merge/Destination component with the "Orphaned Children Error Output" output enabled. 
  • New: We added Google Analytics v4 API support in Google Analytics components. This is a breaking change, as a prior version (v7.1 or earlier) would not be able to process an SSIS package that contains a Google Analytics Connection Manager using v4 API version.
  • New: Fuzzy Match in Premium Lookup component now supports token based match algorithm.
  • New: We added a new option called Host Key Algorithm in SFTP Connection Manager, which can be used to set preferred host key (server key) algorithm.
  • New: We added an Encoding option in SFTP Connection Manager which can be used to decode the file system information on an SFTP server.
  • New: We added a Use Streamed Download option in SFTP Connection Manager which can be used to download large files from an SFTP server.
  • New: We added a new spawn type/anonymization type called "CountryAbbreviated" in Data Spawner/Data Anonymizer components, which can be used to generate country abbreviation values.
  • New: Email spawn type/anonymization type in Data Spawner/Data Anonymizer component now supports providing a static domain value.
  • Enhancement: We have updated the license manager program to now report details of distinct connections in use.
  • Enhancement: Improved UI performance with select/unselect all output columns in Premium Lookup component.
  • Enhancement: Some code refactoring for better performance with a large number of lookup rows in Premium Lookup component.
  • Update: JSON Source component no longer fails when the service call response is empty.
  • Update: We updated the default report version to v201806 for Google Ads/AdWords Connection Manager.
  • Update: The performance of JSON/XML Destination/Merge components can be significantly improved by sorting the link key columns in the upstream.
  • Fixed: Our software may report a connection metering related error during runtime for some specific system environments.
  • Fixed: Retry on Intermittent Errors option in HTTP Connection Manager may not work properly.
  • Fixed: You may run into "Stream was too long" error when downloading a large file (>10G) from SFTP server using Premium File Transfer Task.
  • Fixed: Premium File Transfer Task may report UnauthorizedAccess exception when downloading files from a read-only permission network sharing folder.
  • Fixed: PGP Task may fail encrypting file when the encryption key did not have a "publickey user ID".
  • Fixed: You may get error "Value cannot be null. Parameter name: bytes" when using POST/DELETE/PUT/PATCH method in HTTP Requester Task component without providing a request body.
  • Fixed: You may run into OutOfMemory error in Premium Lookup component when performing fuzzy match with a large number of lookup rows and the lookup data contains empty string values.
  • Fixed: Premium Lookup component may report "System.ArgumentOutOfRangeException" error when using a non-string type column as the matching key.
  • Fixed: Premium Excel Source component may report "File does not exist" error when using Box Connection Manager with a valid source file path.
  • Fixed: You may run into "Folder does not exist" error in Premium Flat File Destination component when using Box Connection Manager with a valid destination file path.
  • Fixed: You may get "startIndex cannot be larger than length of string" error in OneDrive Destination component when writing to root directory.
  • Fixed: Premium ADO.NET Destination component using Update or Upsert action may fail with error "Incorrect syntax near 'W'" when the component was created by version 4.0 or earlier and upgraded to v7.1.
  • Fixed: You may get "Invalid column name" error in Premium ADO.NET Destination component when Bulk reporting outputs are enabled while performing Bulk Update/Upsert/Delete and Full Sync actions with column name contains special characters like "-".
  • Fixed: Premium ADO.NET Destination component may drop the time part of the input datetime value when writing to Oracle DATE type field.
  • Fixed: HTML Merge component may generate "Microsoft.SqlServer.Dts.Pipeline.BlobColumn" value in the merged document when input column is DT_NTEXT/DT_TEXT type.
  • Fixed: Google Analytics Source component may drop the millionseconds information when retrieving custom datetime dimension value.
  • Fixed: Opening Analytics View dialog in Google Analytics Source component may crash Visual Studio in a very unique situation when the Google Analytics account has no web properties under the account.
  • Fixed: Google Sheet Source component may crash if the specified sheet id does not exist.

Version 7.1 - June 1, 2018

This release comes with the following updates and enhancements:

  • New: We added Full Sync action support in Premium ADO.NET Destination component, which can be used to synchronize table data when working with Sqlclient Data Provider and Oracle Data Provider for .NET.
  • New: We added a Command Timeout option in Premium ADO.NET Destination component.
  • New: We added a Batch Size property in Premium ADO.NET Destination component, which can be used to specify how many records you want to send to the target database at a time when option "Use Bulk" is enabled.
  • New: We added a Duplicate Handling option in Premium ADO.NET Destination component, which can be used to specify how input duplicates should be handled when "Use Bulk" option is enabled on Update/Upsert/Delete/Full Sync actions
  • New: Premium Slowly Changing Dimension component now supports writing to target database table directly through an ADO.NET connection.
  • New: OAuth Token Generator component now supports OAuth 2.0 JWT authentication flow.
  • New: We added Client Credentials grant type support in OAuth Token Generator.
  • New: We added Country Match support in Diff Detector, Duplicate Detector and Premium Lookup components, which can be used to match English short country name with country code according to ISO 3166-1 standard.
  • New: We added US State Match support in Diff Detector, Duplicate Detector and Premium Lookup components, which can be used to match Canada and United States subdivision names with codes according to ISO 3166-2 standard.
  • New: We added a FileContent spawn/anonymization type in Data Spawner/Data Anonymizer, which can be used to generate random binary column data based on files stored in a provided folder.
  • Enhancement: Improved UI performance with select/unselect all columns in Data Spawner component.
  • Enhancement: Premium Lookup now supports comparing numeric keys of different data types.
  • Enhancement: Grant Type in OAuth Token Generator component now accepts type-in values.
  • Enhancement: Automatically paired fields in Diff Detector component now default to Exact Match match type.
  • Update: Bulk option in Premium ADO.NET Destination component when using Update/Upsert/Delete action with Sqlclient Data Provider now has 3 default outputs: Bulk Reporting Output - Deleted Records, Bulk Reporting Output - Inserted Records, and Bulk Reporting Output - Updated Records. This change should be considered as a breaking change, as a prior version (v7.0 or earlier) would not be able to open or process an SSIS package saved by the new version.
  • Update: When an email fails to process in Email Source component, the component now reports error log information in SSIS execution result instead of failing the component.
  • Fixed: Premium ADO.NET Destination may report pre-execution error "Invalid object name 'xxx'." when destination table name contains "." (dot).
  • Fixed: "Use Identity Insert" may work improperly when writing to a SQL table using "Use Bulk" in Premium ADO NET destination component.
  • Fixed: You may get "Could not find Access Token" error when creating a new OneDrive Connection Manager. 
  • Fixed: Duplicate Detector may work improperly when performing First Name/Company Name Match and options "Ignore Case" and "Ignore Leading and Trailing White Spaces" are disabled.
  • Fixed: You may run into "Value cannot be null. Parameter name: source" error when querying Google BigQuery table data using Google BigQuery Source component and the source command returns 0 rows.
  • Fixed: Test Connection in HTTP Connection Manager may remove "access_token" query parameter which is added manually in Base URL for non-oauth authentication types.
  • Fixed: JSON Source/Extract component may output numeric values incorrectly when local system format setting uses "," (comma) as the decimal symbol.
  • Fixed: Premium Derived Column component may output "Microsoft.SqlServer.Dts.Pipeline.BlobColumn" value when casting a null DT_NTEXT value to DT_WSTR/DT_STR.
  • Fixed: You may get error "System.IO.IOException: The process cannot access the file because it is being used by another process." when uploading local files to Box using Premium File Transfer Task with option "Delete Item From Source Upon Completion" enabled.

Version 7.0 - April 26, 2018

This release comes with the following updates and enhancements:

  • New: We added the following new components:
    • Cloud Storage
      • Box Connection Manager
      • Box Source
      • Box Destination
    • Data Quality and Comparison
      • Address Verification Connection Manager
      • Address Verification
    • Google Services
      • Google BigQuery Connection Manager
      • Google BigQuery Source
      • Google BigQuery Destination
    • Miscellaneous Components
      • EDI Source
  • 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.
  • New: We added a new spawn type/anonymization type called "RandomString" in Data Spawner/Data Anonymizer component, which can be used to generate random strings.
  • New: We added a new spawn type/anonymization type called "IncrementalValue" in Data Spawner/Data Anonymizer component, which can be used to generate incremental numbers.
  • New: We added Move Column and Clone Column capabilities in Data Spawner component.
  • New: We added ZipCode format support in Data Spawner and Data Anonymizer components.
  • New: We added spawn order support for Custom type in Data Spawner and Data Anonymizer components.
  • New: We added a new option called "Decimal Places" for numeric types in Data Spawner and Data Anonymizer components, which can be used to control the decimal places for the spawned/anonymized number.
  • New: OAuth Token Generator now supports specifying additional Request Header when requesting a token from a service.
  • New: We added Password grant type support in OAuth 2 Token Generator.
  • New: We added a "Custom" Access Token location option in HTTP Connection Manager when OAuth2 authentication mode is selected, so that OAuth access token can now be inserted in any location of the HTTP requests in whichever way needed for Web Service, and JSON/XML Source/Destination components.
  • New: Testing connection in HTTP Connection Manager now reports Request Duration, which can be used for some preliminary benchmarking.
  • New: We added PATCH method support in HTTP/Web Services components.
  • New: HTTP Requester data flow component now supports outputting HttpStatusCode, HttpStatusCodeName and HttpResponseUrl in default output.
  • New: We added optional Request Body and Response Body fields to the Default Output of Web Service Destination component.
  • New: XML Source component and Destination component now support importing XML structure and columns from WSDL files.
  • New: We added a Bucket option in Amazon S3 Connection Manager, which can be used to specify a particular S3 bucket to work with.
  • New: We added Fixed Width text file support in Premium Flat File Source and Destination components.
  • New: We added a "Delete Item From Source Upon Completion" option in Premium File Transfer Task, which can be used to delete the source items when file transfer is completed.
  • New: We added OneDrive shared files support in OneDrive components.
  • New: We added a new option called "Keep Alive Interval" in SFTP Conenction Manager, which can be used to send empty packets to SFTP server periodically to prevent the connection from being closed by the server. 
  • New: We added two logging related options to SFTP connection manager, so you can now specify a log file to write to, and the log level that is needed.
  • New: We added a new option to the Azure Service Bus connection manager - IgnoreCertificateErrors, which can be used to ignore any SSL certificate errors.
  • New: We added "Add Wrapping Root Node" option in JSON Merge and JSON Destination components, which can be used to generate more JSON structures. 
  • New: We added a RemoveDiacriticalMarks method to the Premium Derived Column component which can be used to remove some special language accents. 
  • New: We added multi-select support using keyboard in JSON/XML Destination/Merge components, so you can drag and move within the document structure, including the support of Delete to delete all selected nodes in one key stroke.  
  • New: Web Service Task and Web Service components now provide a dialog to help enter SOAP headers with ease through a popup window.
  • New: MSMQ, RabbitMQ and Azure Service Bus components now support reading/writing binary message data directly.
  • New: Azure Service Bus components now support encoding for text messages.
  • New: We added a new "Retry on Intermittent Errors" option in Azure Service Bus Connection Manager.
  • New: We added a new "Ignore Certificate Errors" option in Azure Service Bus Connection Manager, which can be used to ignore any SSL certificate errors.
  • Enhancement: We added command line support for Google Token Manager program.
  • Enhancement: We added command line support for OneDrive Token Manager program.
  • Enhancement: Better bulk action support in Premium ADO.NET Destination component to avoid potential SQL Server merge concurrency issues.
  • Enhancement: More robust support for complex WSDL files in Web Services components.
  • Enhancement: More robust support for different string type parameters in WSDL files in Web Service components.
  • Enhancement: Better length detection for certain spawn types in Data Spawner component.
  • Enhancement: Improved UI performance when loading table metadata in Premium ADO.NET components.
  • Enhancement: We improved the error handling when incoming full path is invalid in Amazon S3 Destination component.
  • Update: We introduced some new metadata and options to the Google Analytics source component, it now supports any date range. This change should be considered as a breaking change, as a prior version (v6.1 or earlier) would not be able to open or process an SSIS package saved by the new version.
  • Update: Premium ADO.NET components now prompt a message when columns are not supported due to their data types.
  • Update: Premium ADO.NET components now exclude those system table schemas from being retrieved when working with Oracle.
  • Update: HTTP Method in HTTP/Web Services components now accepts type-in values.
  • Update: Web Service components now list the namespaces specified in the WSDL file.
  • Update: Premium File Transfer Task now creates the directory path when sending a file to a path that does not exist in local file system.
  • Update: We surfaced some additional advanced SFTP settings in SFTP Connection Manager UI, which used to be only available in its Properties window in v6.1.
  • Update: We updated the default report version to v201802 for Google AdWords connection manager.
  • 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: Data Anonymizer component did not overwrite input values when working with DT_NTEXT and DT_TEXT fields.
  • Fixed: For some special WSDL files, the Web Service Task component might create a request message with invalid namespace prefixes which may not be properly processed by the service on the server side.
  • Fixed: JSON Destination component may report "Http response body is invalid JSON" error when the service call response is empty.
  • Fixed: You may get "One or more of the passed properties are invalid" error when selecting "None" as Encryption Algorithm in MSMQ Destination component.
  • Fixed: The mappings in Data Profiler component may get mixed when reopening an existing package. This fix is a breaking change, as a prior version (v6.1 or earlier) would not be able to process an SSIS package that contains a Data Profiler component saved in new versions.
  • Fixed: The column mappings in JSON/XML Destination/Merge component may get mixed when reopening an existing package. This fix is a breaking change, as a prior version (v6.1 or earlier) would not be able to process an SSIS package that contains a JSON/XML Destination/Merge component saved in new versions.
  • Fixed: Test Connection in HTTP Conenction Manager may add duplicate access_token query parameters in the request URL when using Put Access Token In Query String option with OAuth2 authentication type.
  • Fixed: Some UI issues in JSON/XML Destination/Merge component when expanding/collapsing nodes in Input Columns design page.
  • Fixed: You may get error "Unexpected character while parsing path indexer: n" when hierarchy grandparent and parent outputs are unchecked in JSON/XML Extract/Source components.
  • Fixed: JSON/XML components may report error "Invalid Expression: Invalid character" when SSIS parameter is used in the expressions.
  • Fixed: Encoded value "%2F" in URL may get decoded when using HTTP/Web Service components.
  • Fixed: Web Service components may throw error "Index was out of range. Must be non-negative and less than the size of the collection" when a selected field is an array but the input is empty.
  • Fixed: Some web service endpoints might report a "Couldn't create SOAP message" error when the Web Service component is built upon a SOAP version 1.2 WSDL file.
  • Fixed: Premium Excel Destination component may write DT_TEXT or DT_NTEXT input string values incorrectly.
  • Fixed: Premium Excel Destination component may ignore the "First Row has Column Name" setting under "Clear and write new" mode.
  • Fixed: Amazon DynamoDB Destination component may write DT_TEXT or DT_NTEXT input string values incorrectly.
  • Fixed: You may run into "The given key was not present in the dictionary" error when using SSIS parameter or SSIS varaible in Text Merge mode in XML Destination component.
  • Fixed: JSON/XML Destination component may still process the action for 0 incoming rows.
  • Fixed: JSON Destination component may not parse response properly when the response is an array of objects.
  • Fixed: Premium Flat File Source component may report error "The MaxBufferSize must be greater than 0" when upgrading to a recent version.
  • Fixed: In some particular situation, you may run into error "Connection Closed" when downloading files from SFTP server.
  • Fixed: You may get "Invalid Request" error when you have a Premium File Transfter task to upload files to OneDrive, and the component is immediately followed by a data flow task that contains an OneDrive destination component which write to the exactly same files using the same connection.
  • Fixed: You may get error "SqlCommand.Prepare method requires all variable length parameters to have an explicitly set non-zero Size" when writing to SQL datetimeoffset type column using Premium ADO NET Destination component.
  • Fixed: Premium ADO NET Destination component tries to retrieve table schemas when opening an exsiting configured component.
  • Fixed: You may run into "Insufficient memory to continue the execution of the program" error when using EncodeBase64() function in Premium Derived Column component to process some large binary contents.
  • Fixed: You may receive a "The given key was not present in the dictionary" error when comparing strings contain extended Latin characters in Duplicate Detector component.
  • Fixed: Diff Detector/Premium Lookup component may find unmatch for spaces and NULL values when advanced comparison settings "Ignore All WhiteSpaces" and "Treat Empty String as Null" enabled.
  • Fixed: You may get error "The value specified for the input parameter, 'parameters_data_type', is not valid" when deploying package with RabbitMQ components.
  • Fixed: You may run into "OutOfMemoryException" when reading files in a recursive fashion using Premium File System Source component.
  • Fixed: Premium File System Source component may not read file contents properly for some files in some special situations.
  • Fixed: API Throttling Rate may work improperly in HTTP Connection Manager.
  • Fixed: Files may get transferred to incorrect location when using Premium File Transfer Task to download files from Amazon S3.
  • Fixed: Files may get transferred to incorrect location when using Premium File Transfer Task to download files from Azure Blob Storage.

Version 6.1 - December 22, 2017

This release comes with the following updates and enhancements:

  • New: We added 6 new functions to the Premium Derived Column component, which provide support for various character escaping and unescaping.
  • New: We added a Service Endpoint option in the Azure Service Bus Connection Manager which can be used to specify an alternate URI instead of the default one when working with Azure Service Bus.
  • Enhancement: Some more high-DPI support improvements.
  • Enhancement: Diff Detector now supports comparing numeric keys of different data types.
  • Fixed: You may get error "Implicit conversion from data type sql_variant is not allowed" when using SSIS variable in Premium ADO.NET Source component.
  • Fixed: Premium ADO NET destination may find no match when using a datetime type field as the matching key.
  • Fixed: You may run into "String was not valid DateTime" error when working with Premium ADO.NET Destination component for some special locale regions.
  • Fixed: The text mode in the XML destination component's expression editor did not work properly.

Version 6.0 - December 14, 2017

This release comes with the following updates and enhancements:

  • New: We added the following new components:
    • Cloud Storage
      • Azure Blob Storage Connection Manager
      • Azure Blob Storage Source
      • Azure Blob Storage Destination
    • Data Quality and Comparison
      • Data Profiler
    • Google Services
      • Google Sheets Connection Manager
      • Google Sheets Source
      • Google Sheets Destination
  • New: Premium ADO NET Destination component now supports Bulk Update/Upsert/Delete actions with SQL and Oracle databases.
  • New: Premium ADO NET Destination component now supports Custom Command action.
  • New: We added a Create Table button in Premium ADO NET Destination component that can be used to create a new table with a default CREATE TABLE statement based on input column metadata.
  • New: Premium Flat File Source/Destination component now support Amazon S3 Connection Manager.
  • New: We added support of allowing duplicate keys in both Old Data and New Data inputs in Diff Detector component, the corresponding options are "Allow Duplicate Keys in Old Data" and "Allow Duplicate Keys in New Data" in the Advanced Settings page.
  • New: OAuth Token Generator now supports specifying the path within the HTTP response (JPath) received to obtain access_token, refresh_token, and expiry.
  • New: JSON Destination and XML Destination now support upload byte array content.
  • New: We added a new comparison option "Treat Empty String as Null" in both Diff Detector and Duplicate Detector components.
  • New: Web Service components now support working with repeating elements.
  • New: We added an option called "Upload Chunk Size" in OneDrive Connection Manager which helps the support of uploading large files.
  • New: PGP Task now supports working with GPG files.
  • New: We added support for cloud storage connections (OneDrive, Dropbox, SharePoint, SFTP, FTPS, and potentially more in the future) in Premium Excel components.
  • New: Google Analytics Source component supports getting specific goals.
  • New: We added column/field filtering capabilities in Cassandra Source component and Premium Flat File Source component.
  • New: We added new functions in Premium Derived Column to convert between DateTime and Unix timestamps called DateTimeToUnixTimeStamp() and UnixTimeStampToDateTime().
  • New: We added new functions in Premium Derived Column to format numbers and datetimes as strings called NumberToString() and DateTimeToString().
  • New: We added new functions in Premium Derived Column to replace nested conditionals called IfElse() and SwitchCase().
  • New: We added a new function in Premium Derived Column to get the line count of a file called ReadLineCount().
  • Enhancement: ReadTextContent() function in Premium Derived Column now supports additional parameters to get specific lines of a file.
  • Enhancement: Premium Derived Column has more accurate design time validation and data type detection when using static values.
  • Enhancement: Commands in Premium ADO.NET Source and Premium ADO.NET Destination components are now parameterized and prepared once before the execution.
  • Enhancement: More robust SSL certificate handling in HTTP Connection Manager, RabbitMQ Connection Manager, Cassandra Connection Manager, MongoDB Connection Manager, and FTPS Connection Manager.
  • Enhancement: Improved detection of SOAP versions in Web Service components.
  • Enhancement: More robust usage of XML namespaces in Web Service components.
  • Enhancement: More detailed reporting when error occurs in Premium Excel Source component.
  • Fixed: You may run into "An item with the same key has already been added" error when using non-string type columns as business key in Diff Detector.
  • Fixed: Premium ADO.NET Source component reported InvalidOperationException error when opening the Preview window.
  • Fixed: You may have trouble opening a Premium ADO.NET Source component when you have a sensitive SSIS parameter specified in the package.
  • Fixed: We fixed the automatic truncation of decimal numbers in the Premium ADO.NET Source component.
  • Fixed: Google Analytics Source component did not save the data type changes made to columns within the Columns page.
  • Fixed: Google Analytics Source component ignored the segment setting but always inputting the "New Visitor" segment.
  • Fixed: When option "Expire Current Dimension Records not found in New Source" is enabled, Premium Slowly Changing Dimension component would expire rows already in the expired state.
  • Update: Update of licensing component to better support servers within a clustered environment to minimize potential false licensing errors.

Version 5.0 - October 6, 2017

This release comes with the following updates and enhancements:

  • New: We added the following new components:
    • Cloud Storage
      • Amazon S3 Connection Manager
      • Amazon S3 Source
      • Amazon S3 Destination
    • JSON & XML Processing
      • HTML Table Source
    • Message Queue Components
      • IBM MQ Connection Manager
      • IBM MQ Source
      • IBM MQ Destination
    • Google Services
      • Google AdWords Connection Manager
      • Google AdWords Source
  • New: We added a new 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: We added Web Services Addressing (WS-Addressing) support in Web Service components.
  • New: We added an option called "SOAP Version" in Web Service components, which can be used to specify the SOAP version used by the Web Services.
  • New: We added a button called "Add From WSDL" in Custom SOAP Headers page in Web Service components, which supports loading SOAP headers from the WSDL file.
  • New: Web Service Source component now supports paging.
  • New: We have added an "Export Settings" button in JSON/XML Source component and Destination component, which can be used to export the configurations.
  • New: We have added an "Import Settings" button in JSON/XML Source component and Destination component, which can be used to import the configurations.
  • New: We added "Client Id" and "Client Secret" options in Google Analytics connection manager, which allows to use your own application to authorize.
  • New: We added a new option to the FTPS connection manager - IgnoreCertificateErrors, which can be used to ignore any SSL certificate errors.
  • New: We added a new function in Premium Derived Column called RegexFindMatch().
  • New: We added a new function in Premium Derived Column called StripHTMLTags().
  • New: Duplicate Detector now supports Fuzzy Match and Advanced Comparison Options on business key fields.
  • Enhancement: Design nodes can now be reordered in JSON Merge, JSON Destination, XML Merge, and XML Destination
  • Enhancement: Premium ADO.NET components connecting to Azure will reconnect and continue execution after a TCP timeout occurs.
  • Enhancement: More robust support for complex WSDL files in Web Services components
  • Enhancement: Added a new Authentication mode to HTTP Connection Manager: Basic Authentication which adds basic authentication headers to HTTP requests.
  • Enhancement: Test Connection in HTTP Connection Manager allows every part of a test http request to be customized, and all parts of the response can be viewed to determine if the test was successful.
  • Fixed: At run time throttle rate can be higher or lower than the rate that was actually set in the HTTP Connection Manager
  • Fixed: HTTP Connection Manager editor can crash in rare situations.
  • Fixed: HTTP Request components may ignore the HTTP Method setting.
  • Fixed: HTTP Requester incorrectly retrieves content length.
  • Fixed: You may get FormatException if you have unselected the _JSON field from outputting in JSON Source component.
  • Fixed: Replace an input DT_NTEXT type column may not work properly in Premium Derived Column component.
  • Fixed: Token() function in Premium Derived Column may work improperly to get the last token.
  • Fixed: You might get "The given key was not present in the dictionary" error when using Fuzzy Match in Duplicate Detector component.
  • Fixed: Client certificate was always required when SSL is enabled in MongoDB Connection Manager.
  • Fixed: You may run into "Incorrect syntax near 'SE'" error when all fields are selected as key fields in Premium ADO.NET Destination component with Update/Upsert action.
  • Fixed: You may get incomplete results when perform large load to Excel file using Premium Excel Destination component.
  • Fixed: You might run into error "One or more of the passed properties are invalid" when sending messages to MSMQ using MSMQ Destination component in some special situations.
  • Fixed: You may get "Bad Request" error when Edit Account Information in Dropbox Connection Manager.
  • Fixed: You may run into error "Permission Denied" when using Premium Transfer Task to work with SFTP server.
  • Fixed: 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: We added the following new components:
    • Premium Data Flow Components
      • Excel Connection Manager
      • Premium Excel Source
      • Premium Excel Destination
    • Data Pack and Unpack
      • JSON Source
      • JSON Destination
      • OAuth Token Manager
      • XML Source
      • XML Destination
    • NoSQL Components
      • Cassandra Connection Manager
      • Cassandra Source Component
      • Cassandra Destination Component
      • DynamoDB Connection Manager
      • DynamoDB Source Component
      • DynamoDB Destination Component
    • Miscellaneous Components
      • Google Analytics Connection Manager
      • Google Analytics Source Component
      • Google Analytics Token Manager
  • New: We added Shared Mailbox and Impersonation support in Email Connection Manager, which is available for Exchange Web Services protocol connection to allow you to access to a shared mailbox or "act as" different user.
  • New: We added DB2 data provider support in ADO.NET source and destination components.
  • New: We added a Connectivity Mode option in Azure Service Bus Connection Manager, which can be used to specify the underlying wire-level protocol used to communicate with Service Bus.
  • New: We added Match Type support in Diff Detector component. This is a breaking change, as a prior version (v3.0 or earlier) would not be able to process an SSIS package that contains a Diff Detector component with "Match Type".
  • New: We added a Default to DT_WSTR option in Premium Flat File source component, which can be used to determine whether applying SSIS type DT_WSTR to all string type columns or using DT_STR with corresponding code page for string columns.
  • New: OneDrive connection manager now supports listing existing tokens.
  • New: We added HTTP Method support in Web Service and HTTP components.
  • Enhancement:  Performance enhancement when loading a large number of columns at design time in Diff Detector.
  • Enhancement:  Performance enhancement when loading a large number of columns at design time in Premium Slowly Changing Dimension.
  • Updated: We hid some Premium ADO.NET components' properties from listing in the Propertities window. This is a breaking change, as any packages will be automatically upgraded, and the package will not work with a prior version once the upgrade is done. 
  • Updated: We have updated the XML node types in XML Extract component to support repeating elements. This is a breaking change, and we automatically upgrade when the component is opened, which may not be compatible with prior versions.  
  • Updated: We have removed the HTTP Method property in HTTP Connection Manager and add HTTP Method support at component level.
  • Fixed: You may lose Local File connection manager in Premium File System components.
  • Fixed: The FileContent field in Premium File System components was using data type 'ntext'.
  • Fixed: The Premium ADO.NET components may fail to get schema information for ODBC connections.
  • Fixed: The Diff Detector may not work properly when performing string comparison.
  • Fixed: The output results can be incorrect if the target dimension table has no currrent data when using Premium Slowly Changing Dimension.
  • Fixed: You may get InvalidCastException error when using DT_IMAGE type columns for comparison in Premium Lookup Component.
  • Fixed: Functions Substring(), HexToBytes(), HexToString() were using test value for validation in Premium Derived Column.
  • Fixed: JSON Extract component has trouble working with a JSON document contains special characters in the JSON name.
  • Fixed: Unselected columns at root level might still get merged in JSON Merge and XML Merge components.
  • Fixed: Web Service components failed to load WSDL file when a contained XSD file is inaccessible.
  • Fixed: Premium File Transfer Task component may hang when uploading large files (>3GB) to SFTP/FTPS server.
  • 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 MSMQ, RabbitMQ, and MongoDB connections in SSIS Productivity Pack which come with the the following nine new components:
    • Message Queue Components
      • MSMQ Connection Manager
      • MSMQ Source Component
      • MSMQ Destination Component
      • RabbitMQ Connection Manager
      • RabbitMQ Source Component
      • RabbitMQ Destination Component
    • NoSQL Components
      • MongoDB Connection Manager
      • MongoDB Source Component
      • MongoDB Destination Component
  • New: SSIS Integration Toolkit for Microsoft OneDrive and SSIS Integration Toolkit for Dropbox are now included in the SSIS Productivity Pack adding an additional 6 SSIS components as well as a token manager utility for OneDrive. For release notes prior please see the Dropbox Change Log or the Microsoft OneDrive Change Log.
    • Dropbox Connection Manager
    • Dropbox Source Component
    • Dropbox Destination Component
    • OneDrive Connection Manager
    • OneDrive Source Component
    • OneDrive Destination Component
    • OneDrive Token Manager
  • Other changes have been made to the following components:
    • New: We added an option called "Use Identity Insert" in ADO.NET destination component, which can be used to allows explicit values to be inserted into the identity column of a SQL table.
    • New: We added support for custom Email header fields in Email source component, which can be added as needed in its editor window.
    • New: "Expand All" and "Collapse All" support have been added in XML Extract and JSON Extract components.
    • New: We added a ProxyMode option to HTTP connection manager, Dropbox connection manager and OneDrive connection manager, which now supports three types of proxy mode: No Proxy, Auto-detect and Manual. 
    • Enhancement: We added a few more properties to SFTP Connection Manager and FTPS Connection Manager, which can be used to improve the performance when uploading/downloading files to/from SFTP and FTPS servers.
    • Update: We changed the default output column name to "DetectedChangeType" in Premium Slowly Changing Dimension (This basically introduces a new SSIS metadata, which is considered as a breaking change - as any packages will be automatically upgraded, and the package will not work with a prior version once the upgrade is done).
    • Update: Some minor UI adjustments including renaming "Lookup Type" to "Match Type" in General page of Premium Lookup component.
    • Fixed: Some UI displaying issues under high DPI settings have been fixed.
    • Fixed: HTTP Connection Manager may not authenticate properly.
    • Fixed: The Auto Detect function for surrogate key in Premium Slowly Changing Dimension may not work correctly when the target dimension table is empty.
    • Fixed: In some special case, you may get "The given key was not present in the dictionary" error when using Diff Detector component.
    • Fixed: You may run into "System.ArgumentOutOfRangeException: Index was out of range" error when using Premium Lookup component in some unique situations.
    • Fixed: When removing columns in Unmatched Rows Output in Premium Lookup component, you may get the following error: 'ColumnIndexOutOfRange'.
    • Fixed: XML Merge and JSON Merge components always output the root matching key value even when the field is unchecked.
  • Update: We have an updated license agreement.

Version 2.0 - January 27, 2017

This release comes with the following updates and enhancements:

  • New: The following ten components have been added to the SSIS Productivity Pack:
    • Premium Data Flow Components
      • Premium Lookup
      • Premium Slowly Changing Dimension
    • Azure Service Bus
      • Azure Service Bus Connection Manager
      • Azure Service Bus Source Component
      • Azure Service Bus Destination Component
    • Data Pack and Unpack components
      • XML Merge
      • XML Extract
      • JSON Merge
      • JSON Extract
    • Miscellaneous Components
      • Time Zone Conversion
  • New : The Premium File Pack is now part of the SSIS Productivity Pack with 2 new components (Premium File System Source and Destination) adding an additional 6 components in total to the SSIS Productivity Pack:
    • FTPS Connection Manager
    • SFTP Connection Manager
    • Premium File System Source
    • Premium File System Destination
    • Premium Flat File Source
    • Premium Flat File Destination
    • Premium File Transfer Task
    • Release notes for the Premium File Pack below, for release notes prior to v2.0 please see the Premium File Pack release note archive page.
      • New:  We added a new data flow component called Premium File System Source component, which can be used to read / retrieve data from a File System including SFTP, FTPS connections.
      • New: We added a new data flow component called Premium File System Destination component, which can be used to write data to a File System including SFTP, FTPS connections .
      • Enhancement: Some code refactoring for better performance when writing to local flat files.
      • Fixed: Premium Flat File source component does not allow rename column name shorter than 7 characters.
      • Fixed: Premium Flat File source component does not allow rename unselected column.
      • Fixed: Premium Flat File source component may return 0 instead of null for number type columns.
      • Fixed: You might run into error when importing external columns contain datatype DT_TEXT or DT_NUMERIC (Thanks to Henrik for reporting this).
      • Fixed: The ConnectionString property of SFTP connection manager and FTPS connection manager cannot be parameterized.
      • Fixed: The item may not get fully overwritten using Premium File Transfer Task send files to local system when "Overwrite Existing Items" option is enabled.
  • The following changes have been made to Diff Detector component:
    • New:  We changed the inputs name to "New Data" and "Old Data" for clarity purpose.
    • New: We added options to enable both new data columns and old data columns to the Changed Rows output in Diff Detector component.
    • Enhancement: We added support for column level similarity threshold configuration.
    • Enhancement: Performance enhancement when loading a large number of columns at design time.
  • The following changes have been made to Premium Derived Column component:
    • Fixed: The length detection might be incorrect when using conditional function in Premium Derived Column component.
    • Fixed: The WriteValueToVariable function does not accept using DT_NTEXT type value as its input.
    • Fixed: The LEFT and RIGHT functions were using test value for validation.
    • Fixed: The Premium Derived Column returns empty value for escaped quote value "/"".
    • Fixed: You may get "Invalid expression error" when using Type Cast expressions.
  • Other changes have been made to the following components:
    • New: We added a Batch Size option in Email source component, which is available for Exchange Web Services protocal connections to allow you to specify how many records you want to retrieve each time.
    • Enhancement:  Some minor UI adjustments including positioning "Generate New Key Pair" button to the bottom in PGP Task component.
    • Update: We changed the default chunk size value to 0 in HTTP Connection Manager.
    • Update: We removed the typing function in SMTP destination component.
    • Fixed: Data Spawner source component may return 0 instead of null for number type columns.
    • Fixed: In some special case, you may get "Error reading JArray from JsonReader. Path" error when sending emails using SMTP Task component.

Version 1.0 - October 24, 2016

This is our first official release of SSIS Productivity Pack.

  • Support for SSIS 2016, 2014, 2012, 2008R2, 2008, or 2005
  • Twenty-Three components
    • Data Generation and Anonymization
      • Data Anonymizer
      • Data Spawner
    • Data Quality and Comparison
      • Diff Detector
      • Duplicate Detector
    • Encryption and Compression Tasks
      • Compression Task
      • PGP Encryption Task
    • Template Merge
      • HTML Merge
      • Text Merge
    • Premium Data Flow Components
      • Premium Derived Column
      • Premium ADO.NET Source
      • Premium ADO.NET Destination
    • Email Components
      • Email Connection Manager
      • Email Source Component
      • SMTP Connection Manager
      • SMTP Destination Component
      • SMTP Task
    • HTTP/Web Service Components
      • HTTP Connection Manager
      • HTTP Requester
      • HTTP Requester Task
      • Web Service Source Component
      • Web Service Destination Component
      • Web Service Task Component
    • Other Task Components
      • Timer Task