Released COZYROC SSIS+ 1.7 SR-2 ( The release includes the following major changes:

Data Flow Task Plus
  • Fixed: Unable to override input column error/truncation row disposition when using 'Derived Column' transformation (Thank you, Damian).
  • Fixed: Empty column mapping use may fail with error "Unable to cast object of type 'System.DBNull' to type 'System.String'" (Thank you, Brant).
Database Partitions Task
  • Fixed: Failed to process tables with non-clustered primary keys (Thank you, Amir).
Dynamics CRM Source
  • Fixed: Component returned date-only attributes incorrectly in UTC (Thank you, Maurizio).
  • Fixed: Component failed with error "The top attribute can't be specified with paging attribute page" when FetchXML top element was used (Thank you, Cosmin).
Excel Connection
  • Fixed: Failed to open Excel files stored in SharePoint (Thank you, Kevin).
Exchange Connection
  • Fixed: Unable to set Mailbox parameter with expression (Thank you, Carl).
  • New: Enabled support for TLS 1.1 and 1.2 protocols.
Google Drive Connection
  • Fixed: Upload action didn't update the existing file but created a new file.
Google Sheets Connection
  • Fixed: Various fixes (Thank you Karen).
HubSpot Connection
  • Fixed: Failed to read data from 'Email Campaign' resource (Thank you, Freddie).
ODBC Destination
  • New: More information reported in case of errors.
Pardot Connection
  • Fixed: Authentication token refresh may fail (Thank you, Porter).
QlikView Source
  • Fixed: Failed to process QVX_QV_DUAL fields containing numeric data (Thank you, Steven).
  • New: Performance improvement.
QuickBooks Desktop Connection
  • New: Enabled support for TLS 1.1 and 1.2 protocols.
REST Destination
  • Fix: Failed with error "Unsupported value type: System.Guid" when processing Guid input (Thank you, Kevin).
REST Source
  • Fixed: Failed with error "Unable to cast object of type 'System.Byte[]' to type 'Jurassic.Library.ObjectInstance'" when trying to read certain fields (Thank you, Gaurav).
Script Component Plus
  • Fixed: Failed to link to script when target platform version was set to SQL Server 2012 in SSDT OneDesigner.
Script Task Plus
  • Fixed: Failed to save parameters on OK (Thank you, Carl).
Send Mail Task
  • New: Vertical bar (|) is now used as attachment separator in Attachment parameter.
Shopify Connection
  • Fixed: Various fixes (Thank you Moe, Gaurav).
SSH Connection
  • Fixed: Incomplete file download when file size between 32kb and 49kb and when using SSH-2.0-FileCOPA or Syncplify server software (Thank you Kevin and Greg).
Zip Task
  • Fixed: Zip decompression failed with error "Wrong Local header signature" when processing certain large files (Thank you, Eric).
  • Fixed: Zip decompression failed with error "End of extra data" when processing certain files created with ComponentOne library (Thank you, Anders).