Blogs

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.

COZYROC SSIS+ 1.6 now officially released

COZYROC SSIS+ 1.6 is out of beta. We can now say this is the most ambitious release of the SSIS+ library. The new release includes 15 new adapters, 8 new connection managers and many other enhancements like support for SQL 2012, dynamic data flow transformations, Dynamics CRM 2011 web services, Salesforce bulk-load API, SharePoint 365 and many others. In total it took 22 months of development to deliver this amazing package. We would like to Thank all our loyal customers for their support and assistance!

Summary of the products available immediately for purchase:

  • SSIS+ Ultimate Subscription at $399.95/Year
  • SSIS+ 1.6 perpetual license at $2,399.95
  • SAS® Adapters license at $2,499.95
  • USPS Address Database / One time purchase at $299.95
  • USPS Address Database / Monthly Subscription at $2,399.95/Year
  • SSIS+ Premium Support at $499.95/Year

For more information, check the purchase page.

Summary of the new / updated components

Known Issues

  • Table Difference component is not working properly under SQL 2012 official. There is a bug in the SQL 2012 serialization code, which is scheduled to be fixed in CU 3.
  • Parallel Loop Task is not always working properly under SQL 2012. We are still trying to determine the root cause. Please contact us, if you experience issues.
  • Lookup Plus component in existing packages is incompatible with SQL 2012. Make sure you check the documentation how to prepare your packages for upgrade to SQL 2012.

Released COZYROC SSIS+ 1.6 Beta 2

It took longer than expected, but SSIS+ 1.6 Beta 2 (1.6.2.0) is now official. The major features included in the new Beta are:

  • Support for SharePoint Online/Office 365.
  • Support for Upsert action in Dynamics CRM Destination component.
  • Support for Dynamics CRM 2011 web services. As a result, COZYROC Dynamics CRM adapters now support Office 365 and Federation deployment.

Check below all other 1.6 Beta 2 – related updates:

  • New: Database Partitions Task now supports ColumnStore index.
  • New: OpenAir Source component now supports custom fields in criteria.
  • Fixed: SQL 2012 compatibility fixes in Script Component Plus.
  • New: Teradata Destination component now handles unlimited amount of columns.
  • New: A new action Upsert in Dynamics CRM Destination component.
  • New: OpenAir adapters are now better at setting up the SSIS column type.
  • Fixed: Many fixes and enhancements in Teradata Destination component.
  • Fixed: SQL 2012 compatibility fixes in Lookup Plus component. Also review the documentation for further information.
  • New: Exchange Connection Manager now supports Office 365 deployment.
  • New: SharePoint adapters now support Office 365 deployment.
  • New: A new parameter in NetSuite Connection Manager for specifying server address.
  • New: Dynamics CRM adapters now support CRM 2011 web services.

Released CozyRoc SSIS+ 1.6 Beta 1

CozyRoc is happy to announce the beta release of SSIS+ 1.6 library. The new version includes support for many additional applications. We hope this new release will make easier the decision of many organizations to adopt SQL Server Integration Services (SSIS) platform as their primary integration facility. A brief list of the new features:

  • Support for SQL 2012
  • Support for Salesforce bulk-load
  • Support for dynamic data flow transformations
  • QuickBooks adapters
  • Teradata bulk-load destination component
  • Sage adapters
  • Dynamics GP adapters
  • OpenAir adapters
  • Template Transformation component
  • NetSuite adapters
  • Exchange Connection Manager
  • SugarCRM adapters
  • Dynamics NAV adapters

Your feedback is greatly appreciated.

Syndicate content