Blogs

Released COZYROC SSIS+ 1.7 Beta 2

We've just released a massive update of the COZYROC SSIS+ 1.7 Beta 2 Library ! In addition to all the REST services supported in the first beta release this update will help you to EXPAND your connectivity to popular CLOUD services like:


In addition to the many improvements and fixes in the REST adapters, the adapters now also include support for composite objects.

Developing and testing is completely free and you don't need a license key.

If you have any questions or comments, please let us know. We're here for you.

Regards,
The COZYROC Team

Released COZYROC SSIS+ 1.7 Beta 1

COZYROC is delighted to announce the availability of a beta release of SSIS+ 1.7. This release includes support for SQL Server 2016 as well as several new components that you've been asking for. We're especially excited about our REST components because they are so versatile. Initially, you can use them for accessing eight different REST services. Keep the requests coming so we know what services are most important to you! Here's a list of the new features in SSIS+ 1.7:

If you have any questions or comments, please let us know. We're here for you.

Regards,
The COZYROC Team

Released COZYROC SSIS+ 1.6 SR-4

Released COZYROC SSIS+ 1.6 SR-4 (1.6.104.0). The release includes the following major changes:

  • Fixed: Dynamics CRM Connection Manager failed with error “http://<server host>:80 end point not found” when trying to connect to Dynamics CRM 2015 Update 1 and above.
  • Fixed: SQL Server 2016 compatibility fixes.
  • Fixed: SFTP Task failed when change remote directory command was disabled on server. Implemented change remote directory command not to be executed when Remote parameter is not specified.
  • Fixed: Dynamics CRM Destination component failed when trying to set salesorder entity as fulfilled (Thank you, Marvin).
  • Fixed: Multiple fixes in SharePoint Source CAML statement design dialog (Thank you, Luigi).
  • New: Regular expressions can now be used in FLEE expressions. Use Regex type to access methods from .NET Regex class.
  • Fixed: Dynamics GP Destination component failed with error “Invalid cast from ‘…’ to ‘CozyRoc.Dynamics.Gp.Service.Amount’“ when processing GL Transaction object (Thank you, John).
  • Fixed: Address Parse component did not return correct Standardized PO Box address when “Check address in reference database” parameter was used (Thank you, Donald).
  • New: A new configuration parameter escape in EDI Source component. The parameter allows specification of escape combination to handle special control symbols like segment delimiters used in the data.
  • Fixed: Dynamics CRM Destination component failed to insert records in stringmap entity (Thank you, Kyle).
  • Fixed: OpenPGP Task failed to decrypt file encrypted with more than one public keys (Thank you, Dominik).
  • Fixed: NetSuite Destination component failed to set custom fields to NULL (Thank you, Dave).
  • Fixed: SAS Data Destination component was not storing date/time column types correctly (Thank you, Steven).
  • Fixed: NetSuite adapters failed to process transaction item custom fields (Thank you, Vijay).
  • Fixed: Dynamics CRM Destination component failed to set entity state in non-US localized target server (Thank you, Angelo).
  • Fixed: Dynamics CRM Destination component failed to resolve incident entity when using Dynamics CRM 2011 web services (Thank you, Maurice).
  • Fixed: SAS Data Destination component failed to create files greater than 2GB (Thank you, Javier).
  • New: A new parameter UpsertMatch for Upsert action in Dynamics CRM Destination component with three options: PrimaryKey, AlternateKeys and DuplicateDetectionRules.
  • New: Support for the new Dynamics CRM 2015 UpsertRequest when using parameter UpsertMatch=AlternateKeys.
  • Fixed: Dynamics NAV Source failed to process more than one PageFilter (Thank you, Lars).
  • Fixed: Excel Task ‘Find Cell’ action returned incorrect result (Thank you, John).
  • New: New parameters for error and truncation rows disposition for dynamic source components in Data Flow Task Plus.
  • Fixed: Dynamics AX Destination component failed to create records in non-derived tables.
  • Fixed: Zip Task failed with error “Hash not valid for use in specified state.” when decompressing certain AES-encrypted packages (Thank you, Jim).
  • Fixed: Dynamics CRM Connection Manager failed with error “ID3242: The security token could not be authenticated or authorized.” when processing for more than 8 hours (Thank you, Tamanna).
  • Fixed: Dynamics GP Destination component failed to report errors in ‘Error Output’ (Thank you, Adriana).
  • Fixed: Dynamics CRM Source component failed when specified FetchXml statement contained apostrophe (’) symbol (Thank you, Andrew).
  • Fixed: Parallel Loop Task failed under SQL 2012 and above with error “Changing the Value of a variable failed because it is a parameter variable. Parameter variables are read-only.” when package contained parameters (Thank you, Ankit).
  • Fixed: Salesforce Destination component will now convert input date/time columns to UTC time.
  • New: FTPS Connection Manager now supports TLS 1.1 and 1.2.
  • New: IMAP Connection Manager now supports TLS 1.1 and 1.2.
  • New: POP3 Connection Manager now supports TLS 1.1 and 1.2.
  • New: SMTP Connection Manager now supports TLS 1.1 and 1.2.
  • Fixed: Dynamics CRM Source component created duplicate column names when using FetchXml statement containing link-entity element with reference to the same entity with two different aliases (Thank you, Andrew).
  • Fixed: Dynamics NAV Destination component failed when the input data contained newline character (Thank you, Lars).
  • New: Dynamics NAV Connection Manager now provides more detailed error messages.
  • Fixed: Various fixes and improvements in the Data Flow Task Plus (Thank you, Ankit).
  • New: A new parameter ImpersonatedUser in Exchange Connection Manager.
  • New: Exchange Connection Manager now supports open of another user mailbox with delegated access.
  • Fixed: Data Flow Task Plus didn’t process the standard Aggregate Transformation properly when the input data was floating and the used aggregation was: Sum, Average, Min or Max (Thank you, Parag).
  • New: A new ‘Set worksheet visible’ action in Excel Task.
  • Fixed: Database Partitions Task failed to process tables with Columnstore Index (Thank you, Nigel).
  • New: SharePoint Connection Manager now supports sites migrated from BPOS (Thank you, Angel).
  • Fixed: Zip Task created incorrect entries when compressing files into Tar package and the Source parameter was UNC absolute path (Thank you, Mark).
  • New: A new parameter IgnoreNullValue in Dynamics CRM Destination component.
  • New: A new parameter IgnoreNullValue in Salesforce Destination component.
  • New: A new parameter MandatoryMapping in Data Flow Task Plus for dynamic destinations with four options: None, Source, Destination and List.
  • Fixed: All COZYROC connection manager failed with error “‘Salt’ attribute for ServerPassword is missing in the project manifest” when using SQL Server 2012 and above and when package protection level was set to EncryptSensitiveWithPassword (Thank you, Karl).
  • Fixed: Dynamics CRM Source failed with error “An error occurred while parsing EntityName…” when input data contained invalid activity party email address (Thank you, Nicholas).
  • Fixed: Database Partitions Task failed to process tables with datetime2 column types (Thank you, Doug).
  • Fixed: SharePoint Source component did not work in dynamic data flow (Thank you, Masthan).
  • Fixed: Dynamics CRM Source component failed to read BooleanManagedProperty attributes (Thank you, John).
  • Fixed: Dynamics CRM Destination component was not detecting unchanged date/time input values properly when IgnoreUnchanged parameter was set to True (Thank you, Jessie).
  • Fixed: Dynamic CRM Destination component failed to handle quote entity state attribute setup (Thank you, Jake).

Released COZYROC SSIS+ 1.6 SR-3

Released COZYROC SSIS+ 1.6 SR-3 (1.6.103.0). The release includes the following major changes:

  • New: Support for SQL 2014.
  • New: Tableau Destination component.
  • Fixed: Zip Task created packages with AES encryption which failed to decrypt with newer versions of WinZip and 7-Zip (Thank you, Barry).
  • Fixed: Data Flow Task Plus used in combination with Parallel Loop Task failed when used with Flat File Source or Destination components (Thank you, Dan Palazotto).
  • Fixed: NetSuite Destination component failed to delete records from custom record type (Thank you, Mark).
  • Fixed: Receive Mail Task failed to process email containing attachments with invalid date metadata (Thank you, Aaron).
  • New: A new parameter Mode in Salesforce Source component with two options: Regular and Bulk. When bulk mode is used, the component will use Salesforce bulk read functionality.
  • Fixed: Amazon S3 Task failed with error “Index was out of range. Must be non-negative and less than the size of the collection.” (Thank you, Carl).
  • New: A new parameter Passphrase in SSH Connection Manager.
  • New: Dynamics AX adapters now support Dynamics AX 2012 derived tables (Thank you, Tom).
  • New: A new parameter AssociationCustom in OpenAir Source component. IncludeCustom parameter is deprecated.
  • New: A new parameter AssociationCustom in OpenAir Destination component.
  • New: QuickBooks adapters now support QuickBooks Online Data Services.
  • Fixed: ODBC Destination component failed to process in 64bit mode.
  • Fixed: Zip Task failed with error “Cannot access a closed file” when trying to create Tar archive without compression (Thank you, David).
  • New: QuickBooks adapters now support DataExt object.
  • Fixed: Data Flow Task Plus failed when using Fuzzy Lookup transformation (Thank you, Matt).
  • Fixed: QuickBooks Source component failed with error “Object reference not set to an instance of an object” when trying to use TxnDeleted object (Thank you, Richard).
  • New: A new ‘Get cell’ action in Excel Task.
  • New: A new ‘Set cell’ action in Excel Task.
  • New: A new parameter ServerFingerprint in SSH Connection Manager to verify remote host fingerprint before authentication.
  • New: A new parameter OrganizationId in Salesforce Connection Manager.
  • New: A new parameter PortalId in Salesforce Connection Manager.
  • New: A new parameter Concurrency in Salesforce Destination component with two options: Parallel and Serial.
  • Fixed: NetSuite Source component failed when using saved search against custom record (Thank you, Mark).
  • Fixed: Dynamics GP Source component returned only first 1000 records (Thank you, Patricia).
  • Fixed: NetSuite Source component failed with error “The maximum number (1000) of records allowed for a READ operation has been exceeded” when having more than 1000 customizations (Thank you, Sam).
  • Fixed: NetSuite’s pricingMatrix composite object was not available for use (Thank you, Rahim).
  • Fixed: Teradata Destination component failed when using column of type ByteInt (Thank you, Alan).
  • Fixed: Data Flow Task Plus failed when Lookup Plus transformation had more than one lookup definition against same input column (Thank you, Fabien).
  • New: A new parameter Attributes in OpenAir Source component.
  • Fixed: Numerous fixes and enhancements in the Dynamics GP adapters (Thank you, Patricia).
  • Fixed: Query component failed when input lookup parameter was NULL (Thank you, Don).
  • Fixed: Excel Destination component failed when multiple instances executed simultaneously against same connection (Thank you, Manasi).
  • Fixed: Parallel Loop Task failed under SQL 2012 with error “A deadlock was detected while trying to lock variables “…” for read/write access. A lock cannot be acquired after 16 attempts. The locks timed out.” when Project parameters were defined (Thank you, Ecki).

Released COZYROC SSIS+ 1.6 SR-2

Released COZYROC SSIS+ 1.6 SR-2 (1.6.102.0). The release includes the following major changes:

  • New: A new parameter MultipleMatch in Dynamics CRM Destination component for use with Upsert action. The choices are: UpdateFirst, UpdateNone, UpdateAll, Fail.
  • New: A new parameter IgnoreUnchanged in Dynamics CRM Destination component to avoid updating entity attributes where the input values match the current values.
  • Fixed: Dynamics CRM Connection Manager failed with error “Security Support Provider Interface (SSPI) authentication failed.” when trying to connect to CRM 2011 on premise server using Windows authentication.
  • New: A new parameter BatchMode in ODBC Destination component. The choices are: BulkOperations, ArrayParameter.
  • New: Salesforce Destination component now permits use of identifier lookup fields for the Upsert action.
  • Fixed: Dynamics CRM Destination component failed with error “String was not recognized as a valid Boolean” when trying to process boolean attributes input data set to 1 (Thank you, Srivenkata).
  • Fixed: QuickBooks Destination component failed to process input data containing diacritic characters. The issue is related to QuickBooks Desktop, which can only process ASCII characters. (Thank you, Richard).
  • Fixed: Dynamics CRM Destination component didn’t include owneridtype attribute for update.
  • Fixed: Dynamics AX Source component failed with error “Value cannot be null” (Thank you, Frederic).
  • Fixed: Dynamic data flows using Derived or Conditional Split transformations failed when used with flat file input data without headers.
  • New: A new parameter “Inactive sessions close” in QuickBooks Desktop Edition Gateway to close sessions after specified time of inactivity.
  • Fixed: OpenAir Source component failed to retrieve custom fields for Costcenter type (Thank you, Tas).
  • Fixed: Dynamics AX Destination component failed with error “Cannot call NEXT, update(), or delete() on buffer where data is selected or inserted in another transaction scope” when updating certain tables (Thank you, David).
  • Fixed: Excel Source Plus component failed with error “The type initializer for ‘#c.#rnf’ threw an exception.” when reading certain files (Thank you, Scott).
  • New: A new ‘Setup virtual file’ action in Stream Task to setup virtual in-memory files for use with the standard Flat File and Excel adapters.
  • New: A new parameter ClearDataChannel in FTPS Connection Manager to specify if data channel is secured (encrypted).
  • New: SharePoint Connection Manager now supports Office 365 deployed systems with Federated (delegated) security (Thank you, Phil).
  • Fixed: Excel Destination Plus component UI didn’t handle correctly output column modification (Thank you, Daniel).
  • New: Support for SQL Server Data Tools (aka VS 2012).
  • Fixed: Excel Destination Plus component failed to process when used in dynamic data flow (Thank you, Dan).
  • Fixed: Zip Task failed with error “CRC mismatch” when processing certain packages containing stored-only files (Thank you, Eric).
  • Fixed: Excel Source Plus failed to process sheet with name containing white space at start or end (Thank you, John).
  • New: NetSuite Source component now supports saved searches.
  • Fixed: Salesforce Destination component failed with error “The remote name could not be resolved” when using bulk-load mode with test service instances.

Scripts: AS2 Send, Salesforce Lookup, Column Encryption, Dynamics CRM bulk delete and More

We have just released 20 brand new script components and tasks:

Released COZYROC SSIS+ 1.6 SR-1

Released COZYROC SSIS+ 1.6 SR-1 (1.6.101.0). The release includes the following major changes:

  • New: Sybase Destination component for bulk load in Sybase database.
  • New: Query Transformation component.
  • New: Redesigned Dynamics GP adapters for better support of composite data.
  • New: Redesigned QuickBooks adapters for better support of composite data.
  • New: Redesigned Sage adapters for better support of composite data.
  • New: Redesigned NetSuite adapters for better support of composite data.
  • New: Dynamics CRM Destination component now supports CRM 2011 bulk-load API.
  • Fixed: Dynamics CRM Source component was inefficient when retrieving from activities in system with millions of activity party records (Thank you, Allen).
  • New: A new Smart Refresh supported in all COZYROC source data flow components.
  • New: Script Component Plus now supports dynamic data flow.
  • Fixed: Numerous fixes and enhancements in Data Flow Task Plus (Thank you, Rushabh).
  • Fixed: Dynamic data flow with Table Difference component was not working properly with arbitrary input columns order. The dynamic data flow will now order the input columns (Thank you, Jasmin).
  • Fixed: Dynamic data flow with error output directed toward flat file failed to process (Thank you, Leona).
  • Fixed: Dynamics CRM Destination component failed with error “The maximum message size quota for incoming messages (2097152) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.” when processing large number of columns in CRM 2011 web services (Thank you, Dave).
  • New: A new ‘Get Partition‘ action in Database Partitions Task to retrieve the partition number of existing partition.
  • New: A new CallerId parameter in Dynamics CRM Connection Manager for setting user impersonation.
  • New: A new ExtendedRemoteFileInfo parameter in Amazon S3 Task to retrieve extended file information: size, last modified, etc.
  • New: Dynamics CRM Connection Manager now supports CRM 2011 web services ActiveDirectory authentication.
  • New: A new ‘Rename remote file‘ action in Amazon S3 Task.
  • New: EDI Source now setups data flow outputs only for looping segments. The previous setup logic will stay the same for existing packages for backwards compatibility.
  • Fixed: Numerous fixes and enhancements in QuickBooks adapters (Thank you, Richard).
  • Fixed: Dynamics AX Destination component failed with error “The supplied method arguments are not valid.” when trying to process input data containing the percent (%) symbol (Thank you, Fabio).
  • Fixed: Exchange Connection Manager failed with error “Value cannot be null. Parameter name: uniqueId” when retrieving list of email (Thank you, Carsten).
  • New: A new InstanceName parameter in Dynamics NAV Connection Manager for setting instance.
  • New: A new ‘Create remote directory‘ action in Amazon S3 Task.
  • New: A new ‘Remove remote directory‘ action in Amazon S3 Task.
  • New: A new parameter RemoteFilter in Amazon S3 Task to set remote file filter expression when using ‘Receive files’, ‘Remove remote files’, ‘Get remote files list’ actions.
  • New: A new parameter LocalFilter in Amazon S3 Task to set local file filter expression when using ‘Send files’ action.
  • New: A new parameter Headers in Send Mail Task to set additional mail headers.
  • Fixed: Dynamics CRM Source component did not handle aliased values in CRM 2011 (Thank you, Yatik).
  • New: A new parameter JobIdVariable in Salesforce Destination component to store bulk job identifier in variable.
  • New: A new parameter ExistingData in Excel Destination Plus component specifying what to do with existing data – Clear, Overwrite or Append. The existing Clear parameter is deprecated.
  • Fixed: NetSuite Connection Manager failed with error “Your connection has timed out. Please log in again.” when trying to connect.
  • New: Dynamics CRM Connection Manager now supports Office 365 deployed systems with Federated (delegated) security.

Scripts: PayPal Transactions, Time Zones, Dynamics CRM Lookup and More

We have just released 10 brand new script components and tasks:

Released COZYROC SSIS+ 1.5 SR-4

Released COZYROC SSIS+ 1.5 SR-4 (1.5.104.0). The release includes the following major changes:

  • Fixed: SFTP Task failed with error “System.OverflowException: Arithmetic operation resulted in an overflow” when trying to process Filter expression containing time span (Thank you, Julian).
  • New: SharePoint Source and SharePoint Destination components now show user-friendlier names for columns containing spaces (Thank you, Michael).
  • New: EDI Source component now provides better diagnostic when column processing fails.
  • Fixed: SFTP Task incorrectly cut the first characters of downloaded file name in certain cases.
  • Fixed: Script Component Plus 2008 failed with error when trying to add input.
  • Fixed: Excel Destination Plus component failed to process input columns of DT_TEXT and DT_NTEXT (Thank you, Marcy).
  • Fixed: Parallel Loop Task now provides better logging information (Thank you, Jonathan).
  • New: Parallel Loop Task can now process parallel loops defined inside For Each Loop (Thank you, Clement).
  • Fixed: Data Flow Task Plus failed to process Recordset mappings after the first iteration (Thank you, Joe).
  • Fixed: Amazon S3 Task failed to process files containing space in name (Thank you, Steve).
  • New: Dynamics AX adapters now support 4.0 version (Thank you, Taylor).
  • Fixed: Zip Task now fails if specified source selection doesn’t contain any files (Thank you, Elena).
  • New: Address Parse component now provides street pre-direction, suffix and post-direction.
  • New: EDI Source component now supports removal of unused outputs and columns.
  • New: Template Task now supports activation of template helper classes.
  • Fixed: Zip Task failed to extract from Tar package containing files larger than 8gb (Thank you, Bob).
  • Fixed: ODBC Destination component failed to load properly DECIMAL type columns in Microsoft Access (Thank you, Geert).
  • New: A new parameter RemotePathSeparator in SFTP Task to set the used remote path separator character.
  • Fixed: Amazon S3 Task ‘Get remote files list’ action returned only the first 1000 files in a bucket (Thank you, Bob).
  • Fixed: ODBC Destination failed to properly close Microsoft Access database, when no input data was provided.
  • Fixed: The library now works properly on FIPS-only systems.

COZYROC Excel Add-In for SAS

COZYROC is introducing the COZYROC Excel Add-In for SAS. This add-in provides the user with the ability to open and save SAS data from within Excel. The add-in does not use SAS for any processing and is 100% standalone. Highlights:

  • SAS datasets are read/written in binary and do not rely on any SAS software or require the SAS datasets to be in XML, CSV, or any format other than sas7bdat.
  • Compatible with Excel 2003-2010.
  • Datasets are written wherever the cursor is placed so insertion at any location within Excel is possible.

More details regarding the add-in can be found here. The Add-In is available for purchase immediately.

Syndicate content